View previous topic :: View next topic
|
Author |
Message |
Piyush Jadhav
New User
Joined: 06 Feb 2014 Posts: 7 Location: India
|
|
|
|
Hi Sir,
I am using SORT FIELDS=COPY, OUTREC FINDREP=(IN=C'True',OUT=C'False') but I want to do this find and replace only for the first "TRUE" found and rest to be skipped or FINDREP should not replace rest of the records having "TRUE" except first record. I tried STOPAFT=01, but that is to copy only single records from whole dataset.
Please let me know in case any more description is needed. |
|
Back to top |
|
|
Joerg.Findeisen
Senior Member
Joined: 15 Aug 2015 Posts: 1306 Location: Bamberg, Germany
|
|
|
|
Add DO=1, and please remember to use Code Tags when displaying code or data to the forum. |
|
Back to top |
|
|
Joerg.Findeisen
Senior Member
Joined: 15 Aug 2015 Posts: 1306 Location: Bamberg, Germany
|
|
|
|
While I was reviewing my answer, and you wish to apply the condition to the first record only, you must add a temporary sequence number. Use that number with what I have already written, discard at a later stage. |
|
Back to top |
|
|
Piyush Jadhav
New User
Joined: 06 Feb 2014 Posts: 7 Location: India
|
|
|
|
Thanks for your input, it got sorted with DO=1. |
|
Back to top |
|
|
|