Forum Discussion

j_logan's avatar
j_logan
Frequent Visitor
4 years ago

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><u+26a1><u+0001f44d><u+2650>

 

Using a text select function didn't help much as it leaves random characters & numbers which leave the sentence unclean.

 

Thank you for the help.

Need Help

1 Reply

  • wdx223_Daniel's avatar
    wdx223_Daniel
    Community Champion
    4 years ago

    NewStep=Table.AddColumn(PreviousStepName,"clean_comment",each Text.Combine(List.Transform(Splitter.SplitTextByDelimiter("<u+")([comment]),each Text.AfterDelimiter(_,">"))))