condition check

[chrisjones]

Hi ,
I am getting some special characters in my source record so I want to check source record characters should be within A-Z,a-z and 0-9 if not then I treat as special charater record....can someone hlep how to write this range condition in datastage.

I tried below stuff in stage variable but not working

if link1.source=[A-Z] and [a-z] and [0-9] then 1 else 0.

Please advice

[nirdesh2]

You can use Alpha() for checking A-Z & a-z and Num() function for checking 0-9 digits. I think this will help you to check any special character.

[nirdesh2]

You can use Alpha() for checking A-Z & a-z and Num() function for checking 0-9 digits. I think this will help you to check any special character.

[ray.wurlod]

Stage variable expressions do not use shell regular expressions, and in particular not range elements of regular expressions.

The AlNum() function reports whether its argument is alphanumeric.