cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
TBenders Regular Visitor
Regular Visitor

Replace entire cell containing specified text (in query editor)

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

1 ACCEPTED SOLUTION

Accepted Solutions
fcarvalho Member
Member

Re: Replace entire cell containing specified text (in query editor)

@TBenders,

 

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

2 REPLIES 2
fcarvalho Member
Member

Re: Replace entire cell containing specified text (in query editor)

@TBenders,

 

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

TBenders Regular Visitor
Regular Visitor

Re: Replace entire cell containing specified text (in query editor)

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