Re: Data handling in mathematica 2.2 and 3.0
- To: mathgroup at smc.vnet.net
- Subject: [mg5735] Re: Data handling in mathematica 2.2 and 3.0
- From: ronnen at ariel.ME.Berkeley.EDU (Ronnen Michael Levinson)
- Date: Sat, 11 Jan 1997 14:29:20 -0500
- Organization: University of California at Berkeley
- Sender: owner-wri-mathgroup at wolfram.com
Hi.
I save my speadsheets as tab-delimited or comma-separated files, and then
set WordSeparator to tab or comma. You might be getting an error if you
have a non-numeric field that you're trying to read as Number.
-- Ronnen Levinson --
<5an6m6$r3i at dragonfly.wolfram.com>,
sean ross <sean at lorien.creol.ucf.edu> wrote:
> How can I get mathematica to read in a text data file without
>first having to massage the data in a text editor? Take your
>typical multi-column data from an excel-type spreadsheet. If I
>save it as text, the ReadList function assumes I want to
>multiply all numbers together than appear on the same line. If
>I save it as comma delimited, ReadList says it is a syntax
>error. I have tried manipulating the RecordSeparator and
>WordSeparator options in ReadList, but no success.
> My current wordaround is to take the data file, read it into
>excel and save it as comma delimited text, then import it into
>word, and do a global replace on all return characters
>converting them into commas, placing a { } around the list,
>saving it as unformatted text. Then ReadList can read the data
>and I can Partition it. I hope there is a more elegant
>solution.
> P.S. Has anybody been able to figure out how to read in
>bitmap data like in the cat picture in the 3.0 "tour of
>mathematica"? Any time I try to read in .bmp files, it just
>generates garbage. Not quite as "mathematica reads in data in
>any format" advertised.
>
>
>
>
>