Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.soft-sys.math.mathematica > #2486

Re: unable to import csv-Data

Show all headers | View raw

Hi,

> I am trying to import some data from a csv-file. But I am absolutely
> unable to get any usefull result. I have tried several options to do
> formating during input, but in every case Mathematica 8 puts several
> csv-columns into one result-column. Because the csv-data contains
> germany encoding, I have tried several conversion options, but
> nothing helps. Here is a snapshot of the csv-data (one headline two
> datalines):

> For me it looks like the CSV-Importer is unable to detect
> NULL-Values  (;;)?!?

I think that the option:

"RepeatedSeparators" -> False

would get rid of that problem, but I'm not sure whether it will make 
everything go right. Alternatively you could also try to StringSplit bz 
hand where a ; appears. This would also have the advantage that you 
could read and process the data in junks with ReadList, which might or 
might not be necessary with 200000 lines of data.

hth,

albert

PS: considering the high standard of data privacy in Europe and 
especially Germany I would be very careful about sending personal data 
of any kind to a newsgroup...

Back to comp.soft-sys.math.mathematica | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

unable to import csv-Data Andre Koppel <akoppel@akso.de> - 2011-05-18 11:17 +0000
  Re: unable to import csv-Data Albert Retey <awnl@gmx-topmail.de> - 2011-05-19 11:44 +0000
  Re: unable to import csv-Data David Bailey <dave@removedbailey.co.uk> - 2011-05-19 11:42 +0000

csiph-web