How to find any one of characters in a string?

[horserider]

Hello,

I have a parallel job. In the transformer, all I need to check if my first column of the source which is 1 character long contains any 1 these character ( any number from 1 -10, or any letter A - Z).

If the column has any other character other than above, I want to simply reject the row.

Is there any function that checks for multiple characters in a string?

[ray.wurlod]

No, but if you convert all of those to "" and check the length of the remainder you have a solution.
Your constraint expression would have the form

Code: Select all

Len(Convert("ABCDEFGHIJKLMNOPQRSTUVWXYZ","",InLink.TheString)) = 0