Text contains

[Kishore_SR]

Hi guys,

I need help in M code,

Let's say I have a text

" How_Much_Do_You_Agree_Or_Disagree_With_Each_Of_The_Following...?_Is_Flavorful_Enough_To_Eat_On_Its_Own" 

Now I want to write the code , if text contains a word "Agree_Or_Disagree" and "?" in it then I want to replace the text whatever comes before "?" as "Agmnt_" and retain whatever comes after "?" as it is.

Thanks in Advance!!

[Kishore_SR]

Hi @wdx223_Daniel 

Thank you for your help.... It works👍

[wdx223_Daniel · Accepted solution]

=if List.ContainsAll({[Column]},{"Agree_Or_Disagree","?"},(x,y)=>Text.Contains(x,y)) then "Agmnt_"&Text.AfterDelimiter([Column],"?") else [Column]