Go to Next Record via Sort

[subhazhere]

i have a file which is having records as below :

6XXXXXX 101.37 Invalid Pos Type
Device

6XXXXXX 120.87 Invalid Pos Type
Device

i want to write the record as

6XXXXXX 101.37 Invalid Pos Type Device
6XXXXXX 101.37 Invalid Pos Type Device

what is the option to do that. Starting position of Invalid word is 41 and file is of 80 bytes. Device word comes in next line in input file and starting position of the word is same as Invalid (41st).

Please help.

[subhazhere]

Can anyone please help me on my queries? Its urgent!

[vikriih]

Device is shown at 1st byte and not 41st byte in the above example. What is actual position 1st or 41st?
What you can do is that you can write a program which reads data from input file and for every two records in the input file it writes only 1 record in the output file. THat way you can move DEVICE word from the second line to the first line next to TYPE. Needless to say that positions need to be specific in the layout file and the file length of 80 should be sufficient to hold the record.

[magesh_j]

You can either use RESIZE ICETOOL or IFTHEN=(WHEN=GROUP,BEGIN=, END= in SORT