RE: Using Excel spreadsheet data on the AS/400

[<groyle@xxxxxxxx> (Gordon S. Royle)]

Not only commas but single and double quotes. We used XLATE to replace any of 
these found in a text description field with spaces just prior to EVALing it 
into the output string, but not until after it "bit" us the first time.

Gord Royle
Cott Corporation
---------- Original Text ----------

From: Phil Groschwitz <sublime78ska@yahoo.com>, on 3/1/01 9:11 PM:

And, each time you open and save the spreadsheet you
may change the lengths of the columns. 

What I have done is require a csv format, and move
each field into character fields of a datastructure. 
Then I test the data to ensure it's the correct
datatype then I do whatever with it.  I also test to
ensure I got the correct number of columns.  If I'm
expecting 8 and only got 7, the alignment of atleast
some of the columns is wrong and you won't know which
one.  Since it's comma delimited, you will have a
problem if there are commas in the data.

phil

--- Joel Fritz <JFritz@sharperimage.com> wrote:
> Fixed length text files can cause problems unless
> you're very careful about
> column formatting.  It's easy to forget that a
> column that has a bunch of
> two and three digit numbers in it has to have a
> length of say, 9 to come in
> to the file on the 400 correctly.  
> 
> 
> 
> > -----Original Message-----
> > From: Vladimir Ivanov [mailto:vivanov@medtac.com]
> > Sent: Thursday, March 01, 2001 7:40 AM
> > To: RPG400-L@midrange.com
> > Subject: Re: Using Excel spreadsheet data on the
> AS/400
> > 
> > 
> > Save the file as type : Formatted text(space
> delimited). This 
> > will create a *.prn
> > file.
> > After just transfer file through FTP to AS400(FTP
> is better 
> > than Client Access in
> > this
> > case, but you can use CA too)
> > 
> > Frank Kany wrote:
> > 
> > > Someone I'm working with is trying to use data
> from an 
> > excel spreadsheet on
> > > the AS400.  If anyone knows of a way to do this
> please let me know.
> > >
> > > TIA
> > >
> > > Frank
> > >
> +---
> | This is the RPG/400 Mailing List!
> | To submit a new message, send your mail to
> RPG400-L@midrange.com.
> | To subscribe to this list send email to
> RPG400-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
> RPG400-L-UNSUB@midrange.com.
> | Questions should be directed to the list
> owner/operator: david@midrange.com
> +---


__________________________________________________
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/
+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---




_______________________________________________________________

Cott - The Leader in Premium Retailer Brand Beverage Innovation. 
_______________________________________________________________
+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---