|
View previous topic :: View next topic
|
| Author |
Message |
meenasomu
New User
Joined: 15 Sep 2005
Posts: 17
|
|
|
|
Hi,
I have the i/p file as
| Code: |
num sal date
A0150000 010107
A0210000 010107
A0145000 020107
A02 7000 020107
|
I need the output as
| Code: |
numsal
A0195000
A0217000
|
I need to do this with SORT.
Can you tell me whether this below sort card will work?
| Code: |
SORT FIELDS = (1,3,CH,A)
SUM FIELDS = (4,5)
OUTREC FIELDS =(1:1,3,4:4,5)
|
|
|
| Back to top |
|
 |
William Thompson
Global Moderator
Joined: 18 Nov 2006
Posts: 3156
Location: Tucson AZ
|
|
|
|
| Without looking it up in the sort manual, it looks roughly right, how does it run? |
|
| Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA
|
|
|
|
| Quote: |
| Can you tell me whether this below sort card will work? |
No, they won't, but these DFSORT control statements will:
| Code: |
OPTION ZDPRINT
SORT FIELDS=(1,3,CH,A)
SUM FIELDS=(4,5,ZD)
OUTREC FIELDS=(1:1,3,4:4,5)
|
|
|
| Back to top |
|
|
|
|
