Convert a file from Vertical Layout to Horizontal Layout
Posted: Fri Apr 27, 2012 5:41 pm
Hi all,
Need to convert the file from vertical layout to Horizontal Layout..
Input File:
Output File:
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.
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.