ashokakash
New User
Joined: 15 Nov 2006
Posts: 21
Location: Chennai
|
|
|
|
Hello all,
Suppose, I want some value from 2nd record being brought to 1st record, how could I do that? Can somebody help me in this?
Input
| Code: |
XXXXXXXXXXXXXXXX 12/31/18 ABCD123
15:15:43
YYYYYYYYYYYYYYYY 12/31/18 ABCD123
15:16:33
ZZZZZZZZZZZZZZZZ 12/31/18 ABCD123
15:17:23
AAAAAAAAAAAAAAAA 12/31/18 ABCD123
15:18:13
|
Desired output
first 4 chars of 1st record, date of first record and time stamp of 2nd record are pushed to the right of first 2 records and this process should go on for every 2 records.
| Code: |
XXXXXXXXXXXXXXXX 12/31/18 ABCD123 XXXX 12/31/18 15:15:43
15:15:43 XXXX 12/31/18 15:15:43
YYYYYYYYYYYYYYYY 12/31/18 ABCD123 YYYY 12/31/18 15:16:33
15:16:33 YYYY 12/31/18 15:16:33
ZZZZZZZZZZZZZZZZ 12/31/18 ABCD123 ZZZZ 12/31/18 15:17:23
15:17:23 ZZZZ 12/31/18 15:17:23
AAAAAAAAAAAAAAAA 12/31/18 ABCD123 AAAA 12/31/18 15:18:13
15:18:13 AAAA 12/31/18 15:18:13
|
|
|
