Forum Discussion
Advocate IHow 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.ReplaceText,{"message"})
How to modify this formula to replace several characters in one step. Or is it ony other way to remove special symbols.
Regards!
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(",.;")))
9 Replies
- Greg_Deckler
Community Champion
Use Text.Trim and specify the optional trimChars parameter:
https://msdn.microsoft.com/en-us/library/mt260494.aspx
- MarcelBeug
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(",.;")))
- arthastic
Thank you guys for your help!
Regards!
- MarcelBeug
Sean I'm afraid you are mixing up "non-essential" with "non-printable".
This solution will not return "MarcelBeug" from my example. :smileylol:
