Re: unable to import csv-Data
- To: mathgroup at smc.vnet.net
- Subject: [mg119011] Re: unable to import csv-Data
- From: Albert Retey <awnl at gmx-topmail.de>
- Date: Thu, 19 May 2011 07:44:57 -0400 (EDT)
- References: <ir09t3$244$1@smc.vnet.net>
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...