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.