Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

tab delimited file to fixed length format

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CLIST & REXX
View previous topic :: :: View next topic  
Author Message
yogesh.jamdar

New User


Joined: 21 Apr 2006
Posts: 4
Location: USA

PostPosted: Sat Sep 02, 2006 2:42 am    Post subject: tab delimited file to fixed length format
Reply with quote

techies,
I have a tab delimted file with variable length (max 27924). It has minimum 29 records of diffferent layout (each line different). Each record is having data separated by TAB. Is there a way to convert this into FIXED length format (layuot available)??
Pls advise.

Yo
Back to top
View user's profile Send private message

superk

Moderator Team Head


Joined: 26 Apr 2004
Posts: 4648
Location: Raleigh, NC, USA

PostPosted: Sat Sep 02, 2006 5:04 am    Post subject: Re: tab delimited file to fixed length format
Reply with quote

Using REXX? Sure, the PARSE function will make easy work of it by using the tab character as the field delimiter.
Back to top
View user's profile Send private message
yogesh.jamdar

New User


Joined: 21 Apr 2006
Posts: 4
Location: USA

PostPosted: Sat Sep 02, 2006 8:31 am    Post subject: Re: tab delimited file to fixed length format
Reply with quote

thanks..wanted to confirm..tried in Cobol by doing an unstring but was getting difficult...had to read to the file byte by byte......hope REXX helps...
Back to top
View user's profile Send private message
superk

Moderator Team Head


Joined: 26 Apr 2004
Posts: 4648
Location: Raleigh, NC, USA

PostPosted: Sat Sep 02, 2006 11:53 am    Post subject: Re: tab delimited file to fixed length format
Reply with quote

Just want to mention that this is also easily handled with products like SAS and DFSORT.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CLIST & REXX All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts splitting a file abdulrafi DFSORT/ICETOOL 2 Fri Mar 24, 2017 11:51 am
No new posts Count the length of the record & ... sreekusr DFSORT/ICETOOL 4 Thu Mar 23, 2017 7:52 pm
No new posts Receive a file using PCOMM macro Harald.v.K IBM Tools 0 Thu Mar 23, 2017 6:50 pm
No new posts How to pick only YYMMDD from DATE1P (... atulbaviskar SYNCSORT 7 Wed Mar 22, 2017 11:39 am
No new posts Export flat file data into excel sheet murali.andaluri DFSORT/ICETOOL 2 Mon Mar 20, 2017 5:39 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us