Syncsort - Converting Columns to rows

rakesh1155 · New User Joined: 21 Jan 2009 Posts: 84 Location: India

hi

My Input is

00001 ABCDEFGHIJKL

My required output is

00001 ABCD
00002 EFGH
00003 IJKL

the length of the column is fixed to 4

Please let me know if this is possible using a sort or any utility

Thanks

Arun Raj · Posted: Fri Oct 01, 2010 8:51 am

Similar topics have been in discussion sometime back. A search might be of help. BTW Which sort product/version are you having?

rakesh1155 · New User Joined: 21 Jan 2009 Posts: 84 Location: India

We have SYNCSORT at our place.

Arun Raj · Posted: Sat Oct 09, 2010 3:19 pm

Which Syncsort version do you have? Also you have shown only one record in your input. Will that be the case always? If not, then please explain all the rules by which you arrive at the output for a set of input records, not just one.

Mention the starting position, length and format of all relevant fields. Input/output file attributes.

rakesh1155 · New User Joined: 21 Jan 2009 Posts: 84 Location: India

Input file:

RECFM=FB, LRECL=85 - it contains only one record.

first 5 bytes are irrelevant, from byte 6, each 4 bytes should come in the next row.

For example:
00001ABCDEFGHIJKLMNOP....

Output:
00001ABCD
00002EFGH
00003IJKL
00004MNOP

For a LRECL= 85 (5 + 20*4)
the output will contain 20 rows. (recfm = fb, LRECL = 80, first 9 bytes with data, and rest 71 bytes as SPACES)

I hope I was able to explain my doubt.

Arun Raj · Posted: Sun Oct 10, 2010 12:53 am

rakesh1155,

The below Syncsort job should do this for you. This is UNTESTED.