If text contains then make cell blank

[Serdet]

Hi,

I have a column which  contains a URL. Some of these URL's contain the text "sig".

Within Power query is it possible to change any URL containing "sig" to a blank entry?

Example before

Url

www.test1234sig.com

www.test1234.com

Example after

Url

www.test1234.com

Many thanks,

Elliot 

[v-yanjiang-msft]

Hi @Serdet ，

Does @CNENFRNL 's solution solve your problem, if yes, please kindly accept it as the solution to help the other members find it more quickly.

Best Regards,
Community Support Team _ kalyj

[CNENFRNL]

= Table.ReplaceValue(Source, each [Url], each if Text.Contains([Url], "sig") then "" else [Url], Replacer.ReplaceText, {"Url"})

or

= Table.ReplaceValue(Source, null, null, (x,y,z) => if Text.Contains(x, "sig") then "" else x, {"Url"})

[Serdet]

Hi,

I have tried option 1 and replaced each [url] with the relevant column but are abit confused what to do with regards to the {"url"} section as I do not have any text that contains the string "url".

[CNENFRNL · Accepted solution]