Forum Discussion
j_logan
4 years agoFrequent Visitor
Q: Removing unicode in text
Hello Community, I'm trying to do some text clean-up but having trouble in removing the unicode. I wish to remove the entire unicode including the character, '+', numbers eg. <u+2665><u+fe0f><...
wdx223_Daniel
4 years agoCommunity Champion
NewStep=Table.AddColumn(PreviousStepName,"clean_comment",each Text.Combine(List.Transform(Splitter.SplitTextByDelimiter("<u+")([comment]),each Text.AfterDelimiter(_,">"))))