Re: Generating PC file formats from AS/400 data

Mark,

I am doing some similar things and I would address it this way:

Change the data to be fixed column widths; this will eliminate any problems
with the quote sign being used in an alpha field causing problems with the
parsing.

Do all of the formatting inside of a Visual Basic for Applications module
(macro).  If someone there knows VB, VBA is almost the same thing.  This
way, your salespeople do what they are paid to do, which is sell stuff -
not - parse data.

You can set it all up so that they just run the macro, select the text file
to import and then watch in amazement as the macro parses the data, resizes
the columns, and does the couple of other things you design to impress the
heck out of them.

Bill

----- Original Message -----
From: "Mark Allen" <markallen@kellyskids.com>
To: "MIDRANGE-L" <MIDRANGE-L@midrange.com>
Sent: Tuesday, August 08, 2000 9:13 AM
Subject: Generating PC file formats from AS/400 data


> . . .However, there are a number of our reps who have little to no PC
expertise
> and they are having major issues (which in turn is causing us more work)
> importing/opening the data in their "program of choice".



__________________________________________________
Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.
http://im.yahoo.com
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---