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