Find using "Contains" Wildcard and replace whole text with new value.

[adelmonte]

Hi all,

I am trying to replace whole text with "Yes" in case it contains "Product" 
Currently, I create a new conditional column, than I remove column, but I would like to do it in one step and simply replace the text.

Current code:
#"Added Conditional Column" = Table.AddColumn(#"Filtered Rows1", "Project", each if Text.Contains([#"Product Based Project"], "Product") then "Yes" else "No")

Thanks in advance.
Alex

(Mr. Amit please don't spam this post.)

[MFelix · Accepted solution]

Hi @adelmonte ,

In this case you need to use the approach on the video below:

I have made a sample file with the formula that should be something similar to the one below:

= Table.ReplaceValue(#"Added Custom", each [Category],  each  if Text.Contains( _[Category], "Product") then "Yes" else [Category] ,Replacer.ReplaceText,{"Category"})

Has you can see the custom column (used for comparision only) give the same result has the one with the ReplaceValue. I also did not replace the full text by "No" to give the comparision between the values but if you change the values by:

= Table.ReplaceValue(#"Added Custom", each [Category],  each  if Text.Contains( _[Category], "Product") then "Yes" else "No" ,Replacer.ReplaceText,{"Category"})

Then result is has below:

[adelmonte]

Muchas gracias Miguel!
Thank you so much!

Best regards,
Alex