Connection condition based on XML Field - no alphanumeric characters

Post Reply
RunDontStop
Member
Posts: 59
Joined: Mon Apr 05, 2021 8:03 pm

Connection condition based on XML Field - no alphanumeric characters

Post 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.
jan_suhr
Advanced member
Posts: 592
Joined: Fri Nov 04, 2011 1:12 pm
Location: Nyköping, Sweden

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

Post by jan_suhr »

You do a RegExp that looks for you alfanumerics and then the logic for the connection is No match.
Jan Suhr
Color Consult AB
Sweden
=============
Check out my apps
RunDontStop
Member
Posts: 59
Joined: Mon Apr 05, 2021 8:03 pm

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

Post 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.
Post Reply