Forum Discussion

Einomi's avatar
Einomi
Icon for Helper V rankHelper V
3 years ago
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,,...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
Vijay_A_Verma's avatar
Vijay_A_Verma
Icon for Most Valuable Professional rankMost Valuable Professional
3 years ago

Equivalent function in PQ is (Data is your column name here)

= Text.Combine(List.RemoveItems(Text.ToList([Data]),{"A".."Z"}))