Subject: | |
From: | |
Reply To: | Emerson, Tom # El Monte |
Date: | Thu, 21 Oct 1999 18:30:43 -0400 |
Content-Type: | text/plain |
Parts/Attachments: |
|
|
> -----Original Message-----
> From: Braun, Dick [mailto:[log in to unmask]]
>
> I am looking for a utility or some code that will run on a
> HP3000 that will
> convert a CSV formatted file that originated on a PC and has been
> transferred to the HP3000 into fixed width fields in a fixed
> length record.
> Anyone have any suggestions?
I know Robelle's "Suprtool" will create CSV's, hadn't thought about going
the other direction [and don't have time to pour through their doc's to see,
but they might be a good place to start regardless...]
Lacking that, a relatively simple MPEX "expression program/command file"
should do the trick -- using the logic recently posted to "read" a file, you
could then use the MPEX "NTOKEN" function to retrieve the "n"th token from a
string [the "buffer" retrieved by reading the file -- break on commas,
naturally...] and then use "STRWRITE(field:SIZE)" to convert to fixed-length
fields.
Tom Emerson
Sr. Systems Analyst
NDC | e COMMERCE
[log in to unmask]
626-258-4309
626-350-3832 FAX
|
|
|