Can you place a formula inside the RegEx tool

[alex]

Can you place a formula inside the regex expresssion?  For example using the match option in the RegEx tool can I tell it to match the value in a specified field inside the workflow by specifiying the field?  .*Field1

[jdunkerley79]

You can't put a formula in the Regex tool, but you can use the REGEX functions within a formula:

- REGEX_CountMatches

- REGEX_Match

- REGEX_Replace

See help document here

[alex]

Thanks for the reply.  I was trying to have the RegEx tool be able to handle the result of a formula instead of having to have a fixed value in the match string.  I guess that's not possible from what I've seen so far.

[jdunkerley79 · Accepted solution]

That is possible in a formula tool but not in the regex tool. 

Try something like:

Regex_match([Field2], ".*" + [Field1])

The regex tool takes a constant I believe so as far as I know no way there. 

[alex]

I didn't think about concatenating the field with the ".*" inside the RegEx_Match function.  Gives me another option besides Contains function.  Thanks!