Forum Discussion
Solved
Power query text methods
Hi everyone, How do I apply a text method in M code to a whole column? I have ColumnA ColumnB 1 abcFred 2 abcJane 3 Markabc 4 Jamabces 5 Emmabca I want Co...
In the query editor, select your column and click on Replace Values in the ribbon. Just leave the 2nd field blank.
Pat
Try this one= Table.ReplaceValue(#"Changed Type","abc","",Replacer.ReplaceText,{"Column2"})
Hope this helps!
Try this one= Table.ReplaceValue(#"Changed Type","abc","",Replacer.ReplaceText,{"Column2"})
Hope this helps!