|
View previous topic :: View next topic
|
| Author |
Message |
Arun Raj
Moderator
Joined: 17 Oct 2006
Posts: 2481
Location: @my desk
|
|
|
|
| Before jumping into conclusions, should n't we be clear on what the TS actually wants and let him respond to the queries raised and which are still unanswered. |
|
| Back to top |
|
 |
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hi Arun,
| Quote: |
| should n't we be clear on what the TS actually wants |
Yup. . .
Until/unless TS provides better info we're just flailing away.
Maybe Vinu will be back on Monday . . .
d |
|
| Back to top |
|
|
vinu78
Active User
Joined: 02 Oct 2008
Posts: 179
Location: India
|
|
|
|
| Sorry everybody. Actually I was out of country. Also my confidence dipped down and I am afraid to post further as I have messed up my wordings. Once again I am sorry to everybody |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
Don't worry about "messed wording". It may take a few iterations, but we Can work thru it.
What is your status for this now? |
|
| Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006
Posts: 2481
Location: @my desk
|
|
|
|
Vinu,
We just want you to pay attention to the details requested for, and just provide them. None here is 'upset' with your 'wordings'.
But when someone takes the time to read through your posts and asks for details just to help you, it does n't seem right to ignore it.
Please feel free to post with confidence, Have a nice day  |
|
| Back to top |
|
|
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 |
|
|
|
|
