Forum Discussion
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,,65,1)),LAMBDA(x,Y,SUBSTITUTE(x,Y,"')))
With Power Query I would like the list of all the functions that were used to write it
My expected result should be, a list with the follwing records
REDUCE
CHAR
SEQUENCE
LAMBDA
SUBSTITUTE
Thanks for your time
9 Replies
You are a genius 🙂
Oh I did not see your post wdx223_Daniel I will give it a try, thanks
Equivalent function in PQ is (Data is your column name here)
= Text.Combine(List.RemoveItems(Text.ToList([Data]),{"A".."Z"}))Thanks Vijay_A_Verma
However, I am not looking for the equivalent in PQ 😊
I would like the list of the functions used (obviously the final goal was not the function itself but rather an example)
