IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

How to copy data with delimters to fixed length file


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Venkata Ramayya

New User


Joined: 03 Dec 2007
Posts: 49
Location: United States

PostPosted: Wed Feb 24, 2016 10:03 pm
Reply with quote

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
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10903
Location: italy

PostPosted: Wed Feb 24, 2016 10:09 pm
Reply with quote

search the forum for examples of the PARSE keyword
Back to top
View user's profile Send private message
Venkata Ramayya

New User


Joined: 03 Dec 2007
Posts: 49
Location: United States

PostPosted: Wed Feb 24, 2016 11:05 pm
Reply with quote

It worked. Great Help! Thanks enrico-sorichetti
Back to top
View user's profile Send private message
View previous topic : : View next topic  
Post new topic   Reply to topic All times are GMT + 6 Hours
Forum Index -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts IGYPG3178-I when compiling a pgm read... COBOL Programming 5
No new posts FileAid move data from two files to o... Compuware & Other Tools 5
No new posts Sorting date into YYYYMMDD, and creat... DFSORT/ICETOOL 13
No new posts To Sort detail records in a file with... SYNCSORT 5
No new posts Structured Data and Nested Loops via ... COBOL Programming 0
Search our Forums:


Back to Top