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

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!

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}", "")

2 Comments
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...

Moderator
Moderator
Status changed to: Not Planned

Thank you for idea! Your idea is interesting to us, but due to several outstanding issues and factors, we have determined that we are unable to include this idea on our road map for the product. However, should we be able to return to your idea in the future we will update the status back to Under Review.