Clean non-printable characters from text

[severynm]

Does powerapps have a function similar to the Clean() function in Excel/PowerQuery to remove non-printable characters from a text string?

I have a SharePoint List with a variety of columns, one of which contains data separated with one or more line breaks. I can clean it up just fine in my Power BI dashboard but have yet to figure out how to do that in Power Apps. Curious if anyone has any ideas....

[gabibalaban · Accepted solution]

Hi @severynm ,

May be one of this formula will help you:

Substitute(yourTextValue, Char(13),"")

Substitute(yourTextValue,Char(10),"")

or

Substitute(yourTextValue,Char(13)&Char(10),"")

Hope it helps !

[severynm]

Thanks! I kind of figured out that was the direction I would have to go. Also thanks for that second option - I did not know you could append things together like that. Useful.