Forum Discussion

Kishore_SR's avatar
Kishore_SR
Frequent Visitor
3 years ago
Solved

Text contains

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!!

Need Help
  • wdx223_Daniel's avatar
    wdx223_Daniel
    3 years ago

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

2 Replies

  • wdx223_Daniel's avatar
    wdx223_Daniel
    Community Champion
    3 years ago

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