Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Regex Expressions and update value with formula on Interface tools

patrick_digan
17 - Castor
17 - Castor

I have an interface tool updating a text input with value = test. I've selected the update value with formulas. Why are the below regex expressions working differently?

 

regex_replace([Destination],"(.*)",'$1')

yields test as expected; however

 

regex_replace([Destination],"(.*)",'test') 

yields testtest. I've attached my sample workflow. Thanks!

 

 

1 REPLY 1
MarqueeCrew
20 - Arcturus
20 - Arcturus

Patrick,

 

Interesting.  I did try using a regex tool and set the field to parse and the regular expression exactly as you specified and got 'test' as a result (different than REGEX_REPLACE).

Capture.PNG

I also modifed the expression to be:  "(^.*)","test" and got it to work the way that you expect.

 

While I don't have a quick answer for you, I can provide you with these two working alternatives.

 

Thanks,

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Labels