Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!
The Product Idea boards have gotten an update to better integrate them within our Product team's idea cycle! However this update does have a few unique behaviors, if you have any questions about them check out our FAQ.

Alteryx Designer Desktop Ideas

Share your Designer Desktop product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

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
Balders
11 - Bolide

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

KylieF
Alteryx Community Team
Alteryx Community Team
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.