Search All of the Math Forum:
Views expressed in these public forums are not endorsed by
NCTM or The Math Forum.



Re: help! to input data...
Posted:
Jun 18, 1996 3:05 AM


In article <4q09hb$g8c@dragonfly.wolfram.com>, Paul Abbott <paul@earwax.pd.uwa.edu.au> wrote: >Ian Collier wrote: > >> Mathematica's ReadList command does not have any builtin options to >> read commaseparated data. > > >A not so neat alternative is: > >In[4]:= ReadList["comma.dat", Table[Word,{3}], WordSeparators>","] >
The notsoneat alternative is required if the data has been output by a spreadsheet program like excel, which does not represent zerovalued entries in the file, e.g.,
1,,3,4,5 6,7,,,10
You need to use
ReadList["comma.dat", Word, RecordLists>True, WordSeparators>","]
Note that the RecordLists option obviates the need to specify how many items are on each line. (In fact, the code shown works even when there are a different number of items on each line.)
For the above data, you'll get something like this:
{"1", "", "3", etc.
When you convert this ToExpression, each "" will turn into Null, which can easily be replaced with 0's using a rule.
Dave Wagner Principia Consulting (303) 7868371 dbwagner@princon.com http://www.princon.com/princon



