Forum Discussion
Solved
How to remove nonessential characters such as punctuation, numbers, web addresses
Hi! Help me please with removing nonessential characters from text column. I use Replace Values function to remove this characters: = Table.ReplaceValue(#"Removed Columns1",",","",Replacer.Replace...
Greg_Deckler: Text.Trim only removes characters at the start or at the end of a text.
My suggestion would be to convert the text to a list of characters, remove the unwanted characters and return the result back to a text.
= Text.Combine(List.RemoveItems(Text.ToList("M,,,a.r;;;celB.;e.u.;g"),Text.ToList(",.;")))
You can also use the User Interface to
Trim - Remove leading and trailing whitespaces from each cell in the selected columns!
Clean - Remove non-printable characters in the selected columns!
"Clean" worked for me - thanks 🙂