View previous topic :: View next topic
|
Author |
Message |
prasanth_urs
New User
Joined: 04 Dec 2006 Posts: 44 Location: Pune,India
|
|
|
|
Hi all,
Please help me in this issue.
I need to exclude records of 10 digit whose first digit is zero using DFSORT.
for eg:-
these are the records
9985632151
0321654987
7412365408
Of these i need to remove the second record.(starting with 0)
Can anyone please tell me the syntax to be used in the DFSORT?
Many thanks in advance. |
|
Back to top |
|
|
guptae
Moderator
Joined: 14 Oct 2005 Posts: 1208 Location: Bangalore,India
|
|
|
|
HI There,
U can use following sort card
Code: |
SORT FIELDS=COPY
OMIT COND=(1,1,CH,EQ,C'0') |
|
|
Back to top |
|
|
prasanth_urs
New User
Joined: 04 Dec 2006 Posts: 44 Location: Pune,India
|
|
|
|
Many Thanks Ekta!!!! |
|
Back to top |
|
|
|