MathGroup Archive 1997

[Date Index] [Thread Index] [Author Index]

Search the Archive

Re: Data handling in mathematica 2.2 and 3.0

  • To: mathgroup at
  • 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


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>,
sean ross  <sean at> 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 
>  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.

  • Prev by Date: Mathematica question (another one)
  • Next by Date: Re: Error in HypergeometricPFQ-package?
  • Previous by thread: Re: Data handling in mathematica 2.2 and 3.0
  • Next by thread: Linux / Unix: 3D graphics->monochrome.