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....
Solved! Go to 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 !
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 !
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.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
192 | |
70 | |
49 | |
47 | |
20 |
User | Count |
---|---|
249 | |
127 | |
84 | |
75 | |
74 |