community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

Remove Zero-Width Spaces with the Data Cleanse tool

Currently zero-width spaces are not removed by the data cleanse tool. This means you can have two visually similar words like Dog and Dog but one is actually longer than the other due to zero width characters. The removal of these zero-width spaces can be added with the formula.

 

REGEX_Replace([_CurrentField_], "\x{200B}", "")

1 Comment
Alteryx Certified Partner

Linking to a thread by @Hollingsworth as solving his idea would make this one redundant.

 

https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Robustly-remove-invisible-characters-and-oth...