How to check for numeric characters field by field
Posted: Fri Apr 23, 2010 12:36 pm
Hi colleagues-
I have to implement the below requirement-
There is a file having column "AREA_CODE" which has values like
US929ABC
US12GH123
USA99CBH09
US999
I need to incorporate the below algorithm using DataStage functions on this column values- Check needs to be applied on 3rd,4th and 5th character..as given below
If AREA_CODE LIKE 'US[0-9][0-9][0-9]' Then "OK"
If AREA_CODE LIKE 'US[A-Z][0-9][0-9]' Then "OK"
Please advice how do we achieve this in DataStage Server jobs [7.1 edition]
Thanks,
Regards,
Suresh
I have to implement the below requirement-
There is a file having column "AREA_CODE" which has values like
US929ABC
US12GH123
USA99CBH09
US999
I need to incorporate the below algorithm using DataStage functions on this column values- Check needs to be applied on 3rd,4th and 5th character..as given below
If AREA_CODE LIKE 'US[0-9][0-9][0-9]' Then "OK"
If AREA_CODE LIKE 'US[A-Z][0-9][0-9]' Then "OK"
Please advice how do we achieve this in DataStage Server jobs [7.1 edition]
Thanks,
Regards,
Suresh