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

[James Womeldorf <jwomeldo@FASTENAL.COM>]

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