I have a tab delimited input file (Hex value '05'). The fields have varying beginning and ending columns. I'd like to create a fixed length output file, with the fields separated by 1 space. I also have date fields, formatted as mm/dd/yyyy, m/d/yyyy, and some with the time of day as well. I'd like to convert these to yyyymmdd format. Can anyone help?
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
I can show you how to use DFSORT to do this, but you need to show me an example of the input records and what you want for the output records. You can use q (or whatever) to indicate a X'05' delimiter. Also, what is the RECFM and LRECL of the input file? Show the various input and output dates in the example as well and indicate where they can occur (e.g. second and fourth fields, any field, ?).
I need to remove the quote marks (") and commas (,).
Create an output file by selecting each field delimited by the comma
The output record should be 450 bytes total fixed length
col1 = 50col2 = 200col3 = 200
So the first record should look like this, (imagine the cols are the specified length according to each colour)
00002 0014 02CORDRAN TAPE FLURANDRENOLIDE
I tried the PARSE, but we don't have that option. Our system proggys are too busy to upgrade right now
Can anyone help out ?
But if you don't have the April, 2006 DFSORT PTF and you can't get your System Programmer to install it, then you can't use PARSE. I don't know of another way to do this with DFSORT other than writing your own E15 exit with the appropriate logic.