Convert a file from Vertical Layout to Horizontal Layout



Support for NetApp SyncSort for z/OS, Visual SyncSort, SYNCINIT, SYNCLIST and SYNCTOOL

Convert a file from Vertical Layout to Horizontal Layout

Postby pjagathis » Fri Apr 27, 2012 5:41 pm

Hi all,

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|


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.
Thanks and Regards,
Jagathis P
pjagathis
 
Posts: 67
Joined: Wed May 04, 2011 5:04 pm
Location: Chennai
Has thanked: 0 time
Been thanked: 0 time

Re: Convert a file from Vertical Layout to Horizontal Layout

 

Re: Convert a file from Vertical Layout to Horizontal Layout

Postby enrico-sorichetti » Fri Apr 27, 2012 6:01 pm

Please do the needful.

Why do not start doing that Yourself ???
You have the need, we do not have the need nor any obligation :evil:

the <SORT> related forums have quite a few examples on how to do it !
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2701
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 139 times

Re: Convert a file from Vertical Layout to Horizontal Layout

Postby dick scherrer » Fri Apr 27, 2012 9:15 pm

Hello,

What should happen if the input "months" are not consecutive?

How many months is the maximum?

What are the recfm and lrecl for the files?
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 92 times


Return to Syncsort/Synctool

 


  • Related topics
    Replies
    Views
    Last post