Forum Discussion
Solved
Extract Text before "("
Dear Community I would like a M code to help me identify "(" in my string then extract the text before it For example, I have the following function in Excel =REDUCE(A2,CHAR(SEQUENCE(26,,...
Equivalent function in PQ is (Data is your column name here)
= Text.Combine(List.RemoveItems(Text.ToList([Data]),{"A".."Z"}))