Need to convert the file from vertical layout to Horizontal Layout..
Input File:
00|X|201203|123|
00|X|201205|789|
00|X|201204|456|
00|X|201205|789|
00|X|201204|456|
Output File:
00|X|201203|123|456|789
3rd field indicates the year and month. So based on that field, i have to write to horizontal layout.
I have to write it in sorted order based on year and month.
03 month value should come as first, then 04 month value, then 05 month value and so on.