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: 44
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

Senior Moderator


Joined: 14 Mar 2007
Posts: 10715
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: 44
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts Writng matched records into output fi... DFSORT/ICETOOL 8
No new posts Compare the file record count percent... DFSORT/ICETOOL 4
No new posts compare two file to find position/dat... SYNCSORT 2
No new posts Secondary index error while loading d... IMS DB/DC 2
No new posts Converting a file from PD to display ... SYNCSORT 4
Search our Forums:

Back to Top