|
View previous topic :: View next topic
|
| Author |
Message |
Aneesh
New User
Joined: 30 Sep 2006
Posts: 60
|
|
|
|
Hi,
I have a flat file FB - 80 bytes - i need to eliminate any recorsd which have any character in the first 20 characters as non-numeric. (Basically only those records which have all the first 20 bytes as numeric should be written to the output file.)
Is there any direct numeric check available in syncsort?
Thanks,
Aneesh. |
|
| Back to top |
|
 |
Alissa Margulies
SYNCSORT Support
Joined: 25 Jul 2007
Posts: 496
Location: USA
|
|
|
|
Hello Aneesh,
This code should produce the desired results:
| Code: |
//SYSIN DD *
SORT FIELDS=COPY
OMIT COND=(1,20,ZD,NE,NUM) |
Regards, |
|
| Back to top |
|
|
Alissa Margulies
SYNCSORT Support
Joined: 25 Jul 2007
Posts: 496
Location: USA
|
|
|
|
... Likewise you could also code
| Code: |
//SYSIN DD *
SORT FIELDS=COPY
INCLUDE COND=(1,20,ZD,EQ,NUM) |
|
|
| Back to top |
|
|
|
|
