View previous topic :: View next topic
|
Author |
Message |
Venkata Ramayya
New User
Joined: 03 Dec 2007 Posts: 49 Location: United States
|
|
|
|
Hi,
I would like to copy data from input file that contains data with delimiters to a another file which should have fixed field lengths
Example :
i/p file :
Record 1 - 121000248;AMERI522;
Record 2 - 1210002483;AMERI5223;
o/p File :
Record 1 - 121000248 AMERI522
Record 2 - 1210002483 AMERI5223
I mean the first field length should be 12 - fixed (121000248 or 1210002483)
second field length should be 15 - fixed( AMERI522 or AMERI5223)
Please advise if we can achieve this thru a simple sort
Appreciate your help
Venkat |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
|
|
search the forum for examples of the PARSE keyword |
|
Back to top |
|
|
Venkata Ramayya
New User
Joined: 03 Dec 2007 Posts: 49 Location: United States
|
|
|
|
It worked. Great Help! Thanks enrico-sorichetti |
|
Back to top |
|
|
|