Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!!
Solved! Go to Solution.
=if List.ContainsAll({[Column]},{"Agree_Or_Disagree","?"},(x,y)=>Text.Contains(x,y)) then "Agmnt_"&Text.AfterDelimiter([Column],"?") else [Column]
=if List.ContainsAll({[Column]},{"Agree_Or_Disagree","?"},(x,y)=>Text.Contains(x,y)) then "Agmnt_"&Text.AfterDelimiter([Column],"?") else [Column]