Page 1 of 1

Connection condition based on XML Field - no alphanumeric characters

Posted: Tue Dec 27, 2022 10:12 pm
by RunDontStop
I have an XML field "Versions". If this field contains any alphanumeric characters I do not want the job to proceed on the connection. Otherwise, proceed. I think this is possible with RegEx but with that, the option is "Matches" or "Does Not Match". I don't think I need a match or no match, I just need to know whether or not the field contains alphanumeric characters.

Re: Connection condition based on XML Field - no alphanumeric characters

Posted: Tue Dec 27, 2022 10:21 pm
by jan_suhr
You do a RegExp that looks for you alfanumerics and then the logic for the connection is No match.

Re: Connection condition based on XML Field - no alphanumeric characters

Posted: Tue Dec 27, 2022 11:34 pm
by RunDontStop
Thank you. I tried these 4 "Does Not Match" conditions joined by AND

^.+[a-zA-Z0-9].+$

^.+[a-zA-Z0-9]$

^[a-zA-Z0-9].+$

^[a-zA-Z0-9]$

which I think means:

anything at beginning, followed by 1 alphanumeric, followed by anything at end

anything at beginning, followed by 1 alphanumeric at the end

1 alphanumeric at the beginning, followed by anything at end

one alphanumeric character and nothing else

I tested and when the field has no alphanumeric anywhere it goes through, and if empty it also goes through. If it meets any one or more of the 4 above conditions it does not go through.