sort card for eliminating records having 49 9's
Posted: Tue Oct 25, 2011 3:59 pm
Hi,
My requirement is to fetch records which do not have 49 9's in position 1-49. I used the following sort card
I got correct result, still i'm looking for easy method.
Can anyone tell me how to write the sort card instead of using all 49 9's, and which sort tool I have to use.
Thanks,
Ashok Raju
My requirement is to fetch records which do not have 49 9's in position 1-49. I used the following sort card
sort fields=copy
omit cond=(1,49,ch,eq,c'9999999999999999999999999999999999999999999999999')
omit cond=(1,49,ch,eq,c'9999999999999999999999999999999999999999999999999')
I got correct result, still i'm looking for easy method.
Can anyone tell me how to write the sort card instead of using all 49 9's, and which sort tool I have to use.
Thanks,
Ashok Raju