can we check if a field is alphanumeric??

nagarajan.dharani · New User Joined: 27 Dec 2006 Posts: 36 Location: Chennai

Hi,

Can some one help me with the following requirement.

I have a fileand it has a two fields EMP_NAME and EMP_ID

The EMP_ID is alpha numeric and it is of 7 characters.

The requirement is like i need to create a list of employees where the EMP_ID has the invalid values.

The invalid values are values other than A-Z and 0-9.

Can we check if a field is alpha numeric, numeric usinf DFSORT.

I would be great if some one help me in this..

Thanks,
Dharani

raak · Posted: Thu Dec 13, 2007 7:16 pm

sorry..couldn't come up with anything other than this..

Craq Giegerich · Posted: Thu Dec 13, 2007 7:50 pm

Except that will consider a numeric or ALPHANUMERIC as being invalid. I think you need to remove the "or (1,7,fs,eq,num)" and change the others to include 0 thru 9 "(?,1,SS,NE,C'ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789'),".

raak · Posted: Thu Dec 13, 2007 7:54 pm

thanks for correcting that craq...

Frank Yaeger · Posted: Thu Dec 13, 2007 11:17 pm

Dharani,

Assuming that EMP_ID is in positions 1-7, here's a DFSORT job that will do what you asked for. You can change the positions if appropriate.

nagarajan.dharani · New User Joined: 27 Dec 2006 Posts: 36 Location: Chennai

Hi all,

Thanks a lot for you help...

Frank, it had worked fine for me. Thanks a lot for your help.

Dharani