|
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: 1255
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: 1255
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 |
|
|
|
|
