We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun 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

Regex Replace Optional Parameter

In the regex tool, there is a checkbox called "copy unmatched text to output".

Unfortunately, if you are using regex from within the formula tool, this is not an option. It would be helpful if this could be added as an optional parameter in the regex formula i.e: 

REGEX_Replace(String, pattern, replace, icase=1, unmatched=1)

Without this, regex outputs can sometimes be confusing, as string characters not specified by the pattern (unmatched) appear in the output. This confusion would be alleviated with the optional parameter.

1 Comment
TheOC
16 - Nebula
16 - Nebula

Good idea!
I feel Regex in a formula should be as closely replicable as Regex in the Regex tool.