Re: Importing CSV (comma separated values) files?

*To*: mathgroup at smc.vnet.net*Subject*: [mg13769] Re: Importing CSV (comma separated values) files?*From*: "P.J. Hinton" <paulh>*Date*: Mon, 24 Aug 1998 05:07:18 -0400*Organization*: "Wolfram Research, Inc."*References*: <6rdn5h$dvg@smc.vnet.net>*Sender*: owner-wri-mathgroup at wolfram.com

On 19 Aug 1998, Joe Gwinn wrote: > I have been trying to convince Mathematica 3.0.1 to ReadList an ordinary > CSV spreadsheet file, without luck. It finds the file OK, then > complains of an unspecified "syntax error" while reading a number. No > useful information is presented; all one knows is that it failed. > > The file contains 240 lines, each line containing 240 non-negative > integer values separated by commas. There are no decimal points or > plus/minus signs. The values range fom 0 to 255. For the record, this > is an output file from a CCD instrumentation TV camera used to measure > fiber optic nearfield flux distributions. > > I have played with various combinations of RecordLists, WordSeparators, > and Number, to no avail. > > Even though 240x240= 57,600 entries, Mathematica was not out of memory. > The kernel has 25 MB, and the Front End has 10 MB, and the two > memory-use thermometers were less than 25% full. If I take the same > file and edit it into Mathematica nested-list format and turn it into a > Mathematica notebook, Mathematica handles the data quite well, so the > problem is purely with the import function. > > > The actual output follows: > > raw2Ddata = > ReadList[fullpath,Number,RecordLists->True (*, > WordSeparators->{","}*)]; Read::"readn": > "Syntax error reading a real number from \!\(\"FWB 4 GB:Gigabit \ > Ethernet:Of\" \\[Ellipsis] \"urs:2D Image Data:50M_OFL.IMG\"\)." > > All I can guess is that Mathematica expects numbers with decimals, and > isn't getting the decimals. If that's true, it's a problem, because > the instruments don't do decimal numbers. Is there an "Integer" > declaration for ReadLists? "Integer" didn't work. > > > Anyway, has anybody managed to get this to work, or have any > suggestions? Did you check the technical support FAQ before posting? http://www.wolfram.com/support/InputOutput/ExternalFiles/CommaSeparatedData.html -- P.J. Hinton Mathematica Programming Group paulh at wolfram.com Wolfram Research, Inc. http://www.wolfram.com/~paulh/ Disclaimer: Opinions expressed herein are those of the author alone.