How to find any one of characters in a string?
Posted: Wed Jul 02, 2008 10:20 am
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?
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?