Re: question: format an excel file (.xls) inside sqr program

[Brian Utter <butter@MCC.MIRACOSTA.CC.CA.US>]

James,
You're right.  I only opened the first file and didn't see the second
attachment.  And the files are as you describe.

James Womeldorf wrote:

> Brian,
> Did you open the file entitled test.csv in a text editor?  I sent two files,
> the first, test.xls was tab delimited and should appear the way you show it,
> the second, test.csv should have been comma delimited and should look like:
> "00010",00010
>
> -----Original Message-----
> From: Brian Utter [mailto:butter@MCC.MIRACOSTA.CC.CA.US]
> Sent: Monday, January 08, 2001 11:19 AM
> To: SQR-USERS@list.iex.net
> Subject: Re: question: format an excel file (.xls) inside sqr program
>
> Well, if you open the file in a text editor, you get this:  "00010" 00010
> There is no comma in the file.
>
> --
> Brian Utter
> Research Analyst
> MiraCosta College
> One Barnard Drive
> Oceanside, Ca 92056
> (760)795-6846
>
> James Womeldorf wrote:
>
> > Wonderful!
> > Thanks for your help.
> > If any of us discovers the way around this I assume we will let the others
> > know.
> >
> > FYI, I get the same results with the attached csv file which I find even
> > more disturbing.  I always felt that when all else fails you could always
> > resort to csv.
> >
> > -----Original Message-----
> > From: Fetzik, John [mailto:JFetzik@SANDC.COM]
> > Sent: Monday, January 08, 2001 10:57 AM
> > To: SQR-USERS@list.iex.net
> > Subject: Re: question: format an excel file (.xls) inside sqr program
> >
> > Using Excel 97 SR-2 I get a single field with the string 00010 00010 in
> it.
> > Sounds like Microsoft changed the defaults yet again with Office 2000.
> >
> > > -----Original Message-----
> > > From: James Womeldorf [mailto:jwomeldo@FASTENAL.COM]
> > > Sent: Monday, January 08, 2001 10:48 AM
> > > To: SQR-USERS@list.iex.net
> > > Subject: Re: question: format an excel file (.xls) inside sqr program
> > >
> > >
> > > Unfortunately that doesn't work for me.  I am using Excel 2000 and am
> > > beginning to wonder if this is a new 'feature' of that version.
> > > Would someone else who is not on Excel 2000 try loading the
> > > attached file?
> > > When I load it I get 2 cells, both of which contain
> > > 10
> >
> >   ------------------------------------------------------------------------
> >
> >    test.csvName: test.csv
> >            Type: Microsoft Excel Comma Separated Values File
> (application/x-unknown-content-type-Excel.CSV)
>
> --
> Brian Utter
> Research Analyst
> MiraCosta College
> One Barnard Drive
> Oceanside, Ca 92056
> (760)795-6846

--
Brian Utter
Research Analyst
MiraCosta College
One Barnard Drive
Oceanside, Ca 92056
(760)795-6846