Alteryx Designer

Find answers, ask questions, and share expertise about Alteryx Designer.

RegEx - Replacement Text Equals Another Column's Cell Value

6 - Meteoroid

I am using the RegEx Replacement tool to strip out a leading "9999" and replace it with the value in another column, in this case the column is called [FileName] which has two rows, each cell containing the same number. Instead the tool is simply replacing the "9999" with "[FileName]".


Can someone please explain how I might be able to solve?



Alteryx Certified Partner

Might be easier in the Formula tool to use the regex replace function.


It would look something like this: regex_replace(field_name,"pattern",[replacement])