Replace entire cell containing specified text (in query editor)

[TBenders]

Hi,

Probably an easy one but I can't find the solution. I have data imported from Google Analytics and I want to replace all values in the column 'Source' that contain varieties of LinkedIn to LinkedIn.

Is there an easy way to do this by replacing entire cell if it contains "inked" to "LinkedIn"?

I have doublechecked that the only sources containing 'inked' are from LinkedIn.

For example

be.linkedin
linkedin
nl.linkedin
touch.www.LinkedIn

Should all become

LinkedIn

The reason I want a 'containing' solution is because I have a bunch of similar cases and I don't want to set seperate 'replace values' for all variances.

Thanks for any help!

Kind regards,

Tom Benders

[Anonymous · Accepted solution]

@TBenders,

You can create a new conditional column with the "contains" operator.

[TBenders]

Thanks @Anonymous for your suggestion! Would have prefered to do this in the same column, but this works great too.