Forum Discussion
arthastic
Advocate I
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.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(",.;")))
Greg_Deckler
Community Champion
Community ChampionUse 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(",.;")))