HP3000-L Archives

October 1999, Week 3

HP3000-L@RAVEN.UTC.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
"Emerson, Tom # El Monte" <[log in to unmask]>
Reply To:
Emerson, Tom # El Monte
Date:
Thu, 21 Oct 1999 18:30:43 -0400
Content-Type:
text/plain
Parts/Attachments:
text/plain (28 lines)
> -----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

ATOM RSS1 RSS2