Forum Discussion
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...
=if List.ContainsAll({[Column]},{"Agree_Or_Disagree","?"},(x,y)=>Text.Contains(x,y)) then "Agmnt_"&Text.AfterDelimiter([Column],"?") else [Column]
