View previous topic :: View next topic
|
Author |
Message |
joelacs0710
New User
Joined: 30 Oct 2007 Posts: 10 Location: China
|
|
|
|
HI
Is there a way we can reformat the dataset using the Sort Utility
INPUT FILE:
12345678901234567890123456789012345678901234567890
REV11000SUDHIR0000RAMESH00000000TOM 00
REV11000AADHIR0000RAMESH00000000TOM 00
REV110001ARRY 0000CHRIS 00000000SUDHIR00
REV11000HARRY 0000CHRIS 00000000SUDHIR00
REV12000CHRIS 0000TOM 00000000NICK 00
COS120001HRIS 0000TOM 00000000NICK 00
COS120002HRIS 0000TOM 00000000NICK 00
COS120003HRIS 0000TOM 00000000NICK 00
COS120004HRIS 0000TOM 00000000NICK 00
CONDITION:
IF COLUMN 1-4 = "REV1" then reformat the dataset
1-4,
6-9,
10,C' ',
11-80
Else
No Changes
OUTPUT FILE:
INPUT FILE:
12345678901234567890123456789012345678901234567890
REV1000S UDHIR0000RAMESH00000000TOM 00
REV1000A ADHIR0000RAMESH00000000TOM 00
REV10001 ARRY 0000CHRIS 00000000SUDHIR00
REV1000H ARRY 0000CHRIS 00000000SUDHIR00
REV1000C HRIS 0000TOM 00000000NICK 00
COS120001HRIS 0000TOM 00000000NICK 00
COS120002HRIS 0000TOM 00000000NICK 00
COS120003HRIS 0000TOM 00000000NICK 00
COS120004HRIS 0000TOM 00000000NICK 00 |
|
Back to top |
|
|
abhishekmdwivedi
New User
Joined: 22 Aug 2006 Posts: 95 Location: india
|
|
Back to top |
|
|
joelacs0710
New User
Joined: 30 Oct 2007 Posts: 10 Location: China
|
|
|
|
Thank you very much for the help.. the job is now working as expected.. |
|
Back to top |
|
|
|