Regex Expressions and update value with formula on Interface tools

Question

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!

RegexTest.yxwz

MarqueeCrew · Accepted Answer

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).

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