Expand my Community achievements bar.

The Community Ideas review for H1 2025 is out now, see which ideas our Product team prioritized and let us know your thoughts.

Remove character spaces from a string

Avatar

Level 3

Hey all,

 

Not really a question but in response to a lot of posts re. REPLACE() not working as expected, thought I'd share this:

REPLACE({value}," ", "\u200B")
 
\u200B removes character spaces in {value}
 
Thanks to @Doug_Den_Hoed__AtAppStore for the steer
 
Hope this helps!
 
Andy
1 Reply

Avatar

Community Advisor


Very nice, Andy!

 

Duly noted for future consideration: thanks for sharing!

 

Regards,

Doug