validate a char or varchar input string as numeric digits

DiscGolfer5000 · Post by **DiscGolfer5000** » Fri May 13, 2011 9:02 am

Is there a way to validate numeric digit-only string input in a parallel job transformer stage? Each character of the entire string must contain digits 0 through 9 only. Periods, negative signs, or any character outside of the 0..9 range needs to be invalid.

I have tried the Num() function and it fails on a decimal.

I have tried the IsValid("uint32", string) function and it also fails on a decimal such as 12.34.

I do not see any built in function to validate numeric digits only or to specify a range or list of characters that the string must match. Is there a built-in way to do this in a parallel job?

Thanks,
Eric

ray.wurlod · Post by **ray.wurlod** » Fri May 13, 2011 5:50 pm

Code: Select all

Convert("0123456789", "", InLink.TheString) > ""

Tejas Pujari · Post by **Tejas Pujari** » Fri May 13, 2011 11:02 pm

Hi Ray,

here it will convert any blank space in "0123456789" with the InLink.TheString and that with the single character which will be 1st character of InLink.TheString and then will be compared with "".

I did not get what your are trying to tell.
Can you please explain how the above code works as my understanding may wrong.

chulett · Post by **chulett** » Fri May 13, 2011 11:48 pm

It removes all numeric digits from the string and then compares the result to an empty string. If there is more than that left, it's not valid.