Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
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.
NewStep=Table.AddColumn(PreviousStepName,"clean_comment",each Text.Combine(List.Transform(Splitter.SplitTextByDelimiter("<u+")([comment]),each Text.AfterDelimiter(_,">"))))
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.