Page 1 of 1

How to find any one of characters in a string?

Posted: Wed Jul 02, 2008 10:20 am
by 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?

Posted: Wed Jul 02, 2008 4:30 pm
by 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