View previous topic :: View next topic
|
Author |
Message |
sreekusr Warnings : 1 New User
Joined: 28 Aug 2006 Posts: 54 Location: Madrid
|
|
|
|
Hi All,
Requirement -
Input file record - (FB file)
Code: |
NAMEA ADDRESSA1 ADDRESSA2
NAMEB ADDRESSB1 ADDRESSB2 |
Expected output
Code: |
<FIELD1>NAMEA<FIELD2>ADDRESSA1<FIELD3>ADDRESSA2
<FIELD1>NAMEB<FIELD2>ADDRESSB1<FIELD3>ADDRESSB2 |
And there could be thousands of input record, So please someone help to figure out a SORT to deal with this?
Thanks and Regards,
Sree |
|
Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
From your example, the data is always in fixed positions. Simple to reformat with BUILD.
However, probably things are not so clear as that. Is the data always in fixed positions? Are trailing spaces OK on fields in the output? |
|
Back to top |
|
|
sergeyken
Senior Member
Joined: 29 Apr 2008 Posts: 2010 Location: USA
|
|
|
|
If input file positions are not fixed but varying, then additionally use
Code: |
INREC PARSE=...,BUILD=... |
For details - RTFM please |
|
Back to top |
|
|
sreekusr Warnings : 1 New User
Joined: 28 Aug 2006 Posts: 54 Location: Madrid
|
|
|
|
Thanks a lot for the quick response. |
|
Back to top |
|
|
|