Splitting a single record in to two lines using sort.

abhicet2003 · New User Joined: 16 Nov 2005 Posts: 21

Hi Can any one please tell me the syntax for splitting a single record in to two lines using sort.

For eg:
If Input file contains

IBM MAINFRAME SORT

Then output should be

IBM MAINFRAME
IBM SORT

murmohk1 · Posted: Mon Apr 02, 2007 9:29 am

Yes it can be done through sort techniques (using seqnum option).

What is the criteria for splitting records? Need more explanation along with examples.

abhicet2003 · New User Joined: 16 Nov 2005 Posts: 21

Please see the example below

Input file contains only 1 record ie
From Col 1 to Col 3 - IBM
From Col 4 to Col 12-MAINFRAME
From Col 13 to Col 16-SORT

Desired Output is
In the first line
From Col 1 to Col 12-IBMMAINFRAME
In the Second line
From Col 1 to Col 7-IBMSORT

Frank Yaeger · Posted: Mon Apr 02, 2007 8:26 pm

abhicet2003,

Here's a DFSORT job that will do what you asked for: