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

tab delimited file to fixed length format


IBM Mainframe Forums -> CLIST & REXX
Post new topic   Reply to topic
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
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

Global Moderator


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

PostPosted: Sat Sep 02, 2006 5:04 am
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
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

Global Moderator


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

PostPosted: Sat Sep 02, 2006 11:53 am
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> CLIST & REXX

 


Similar Topics
Topic Forum Replies
No new posts FTP VB File from Mainframe retaining ... JCL & VSAM 4
No new posts Store the data for fixed length COBOL Programming 1
No new posts Extract the file name from another fi... DFSORT/ICETOOL 6
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts Populate last day of the Month in MMD... SYNCSORT 2
Search our Forums:

Back to Top