Free Trial

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

Enhancing Data Cleaning

I have a sales column in my dataset that includes both a dollar sign and a period (e.g., '$320,000.00'). When I use the data cleaning tool and select 'Remove unwanted characters' with the punctuation checkbox, it removes both the dollar sign and the period. However, I only want to remove the dollar sign. It would be great if @Alteryx could allow users to specify which character they want to remove after selecting the punctuation checkbox. Thanks!

1 Comment
jackchoy
7 - Meteor

Hard agree.  Being able to specify specific punctuation characters as part of Data Cleansing would be very useful.  I can't imagine a single case where somebody wants to cleanup special characters in what should be a numerical data, and would want to get rid of the negative signs and decimal points!