In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start 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

Replace function in Regex tool to allow use of fields

It would be absolutely marvellous if the ability to use a field as the replace value could be incorporated into the Regex tool. Currently the "Replacement Text" field is a hardcoded text value, and so to make that dynamic you have to wrap the tool in a batch and feed in the value as a Control Parameter. If we could just select a field to use as the replacement value, that would be spiffy.

 

mceleavey_0-1647001959072.png

 

M.

4 Comments
cgoodman
ACE Emeritus
ACE Emeritus

You can use a field if you use regex_replace() in a formula tool. So it would be great to see this added to the UI of the regex tool. As it is likely that new users will follow a more guided approach by using the regex tool, but as users develop more complex workflows they will likely transition to the formula tool; for example as they want to do a multi step process and don’t want to bring in multiple regex tools to the canvas. But eliminating the differences between what you can do with a formula vs a tool would be great for usability.

fmvizcaino
17 - Castor
17 - Castor

Great idea! The regex tool is amazing already, but this and other suggestions would make it way better than using the regex functions in the formula tool

DavidP
17 - Castor
17 - Castor

Any idea with the word "marvellous" in it deserves my vote @mceleavey!!!

 

In addition it happens to be a great idea and as @cgoodman said, it would give the Regex tool the same functionality that already exists in the regex_replace formula.

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