Connection condition based on XML Field - no alphanumeric characters
-
- Member
- Posts: 59
- Joined: Mon Apr 05, 2021 8:03 pm
Connection condition based on XML Field - no alphanumeric characters
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
You do a RegExp that looks for you alfanumerics and then the logic for the connection is No match.
-
- Member
- Posts: 59
- Joined: Mon Apr 05, 2021 8:03 pm
Re: Connection condition based on XML Field - no alphanumeric characters
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.
^.+[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.