Happy 8th birthday to the Maveryx Community! Take a walk down memory lane in our birthday blog, and don't miss out on the awesome birthday present that all Maveryx Community members get to take advantage of!

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

Data Cleansing Trim and Replace Specific Characters / Sentence Feature

Hi All

 

I thought that this idea might be helpful for users who wanted to remove or trim specific characters without having to write regex formula or multiple replace formula, so I made some change to data cleansing macro tool and add some new feature that can be used for trimming or replace specific characters without having to spend time to write formula / multifield formula, just need to configure data cleansing tool and it's done 

 

For example, I trim the quote symbol without having to remove another symbol, or in case there's another quote in the data, Since I use the trim function, it won't remove the quote symbol inside the sentence too, only the quote symbol at the left and right of the sentence.

 

wellyLiyanto_0-1585635877252.png

 

Also, it can be used to replace a specific word(like find and replace, but without having to create a dataset to replace the word) and can be used for multiple fields,  at the example below I replace NA to 0.

 

wellyLiyanto_1-1585636895662.png

 

Cheers

 

Welly

2 Comments
KylieF
Alteryx Community Team
Alteryx Community Team

Thank you for submitting your feedback to the Alteryx Idea product board!

We appreciate all the feedback we get and are working to review and respond to all ideas that have met the criteria to be brought to our product team. If you haven’t yet, please be sure to review our updated Submission Guidelines.

AlteryxCommunityTeam
Alteryx Community Team
Alteryx Community Team
Status changed to: Accepting Votes