>Some background: I have a table that is being generated on a daily basis. I need to run a few scans on the table to validate the data. One of the these checks involves making sure the social security numbers are ONLY numbers. If it does find a character in one of the fields, then I should get a message box alerting me of the error.
>
>For example, this is something along the lines of what I need to do.
>
>use export
>scan
> if (any digit of the ssn is not 1 - 9)
> wait window "SSN error" at 20,70
> endif
>ENDSCAN
>
>Any help would be appreciated.
>Thanks
>
>Ramone
Hi,
I suppose your field is character data type.
You can use this:
if len(chrtran(SSN, '0123456789', ''))>0
wait window "SSN error" at 20,70
Venelina Jordanova
Outsourcing IT Services Ltd.