|
View previous topic :: View next topic
|
| Author |
Message |
vinu78
Active User
Joined: 02 Oct 2008
Posts: 179
Location: India
|
|
|
|
Hi Dick,
Thanks for the motivation.
From a record with 10 byte, whenever first 6 byte matches (can be 3 or 4 records), I would like to merge the 8th column data, 9th column data and 10th column data onto a single record.
| Code: |
Input is
ABCDEF X
ABCDEF Y
ABCDEF Z
MNOPQR Y
MNOPQR
UVWXYA
Output is
ABCDEF XYZ
MNOPQR Y
UVWXYZ |
Thanks
Vinu |
|
| Back to top |
|
 |
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
| Quote: |
| Thanks for the motivation. |
You're most welcome 
To do what you want, use your key (1-6) and in the INREC use IFTHEN, WHEN INIT, and PUSH the "x,y,z" values. Then in the OUTFIL, BUILD your re-formatted output records.
There should be examples here in the forum. |
|
| Back to top |
|
|
vinu78
Active User
Joined: 02 Oct 2008
Posts: 179
Location: India
|
|
|
|
Thanks Dick for the guidance. I will try that.
Thanks
Vinu |
|
| Back to top |
|
|
|
|
