Expand my Community achievements bar.

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

Level 10


Very nice, Andy!

 

Duly noted for future consideration: thanks for sharing!

 

Regards,

Doug