Using a Regex Match for specifc characters

[R_L]

Hello,

I'm trying to write a condition for a Regex Match.

The string comes in the following format: 12345 AND 123456.

If there is a match for the above, i.e. /d* AND /d*

I want it to generate in another field, the text, "Match".

I've tried the following, but no joy:

if REGEX_Match([Field1], "[(\d*\sAND\s\d*)]") then "Match" else "No Match" endif

Any help please?

[mattreynolds · Accepted solution]

Just need to remove the brackets in the Regex: 

if REGEX_Match([Field1], "\d*\sAND\s\d*") then "Match" else "No Match" endif

Example workflow is attached. Hope this helps!