|
View previous topic :: View next topic
|
| Author |
Message |
shrutika
New User
Joined: 10 May 2008
Posts: 5
Location: India
|
|
|
|
Hi all,
I have an input file as follows
1 354689 99887
2 467648 99767
3 756596 99475
2 677687 99445
3 846577 99746
I want a sort card to copy these to an output file, with the value in column 10 to 11 changed to 88 instead of 99, whenever value in column 1 is 2.
i.e. my output file would look like:
1 354689 99887
2 467648 88767
3 756596 99475
2 677687 88445
3 846577 99746
Thanks...
Shrutika |
|
| Back to top |
|
 |
ksk
Active User
.jpg)
Joined: 08 Jun 2006
Posts: 355
Location: New York
|
|
|
|
Use the following DFSORT statements.
| Code: |
OPTION COPY
INREC IFTHEN=(WHEN=(1,1,CH,EQ,C'2'),
OVERLAY=(10:C'88'))
|
|
|
| Back to top |
|
|
shrutika
New User
Joined: 10 May 2008
Posts: 5
Location: India
|
|
|
|
I tried the above card, and got exactly what i wanted
Thanks everybody.. |
|
| Back to top |
|
|
|
|
