Re: Reading csv with ;
- To: mathgroup at smc.vnet.net
- Subject: [mg99493] Re: Reading csv with ;
- From: dh <dh at metrohm.com>
- Date: Wed, 6 May 2009 05:29:55 -0400 (EDT)
- References: <gtp1h5$k58$1@smc.vnet.net>
Hi Dennis,
assume we have a file:
1;2
3;4
we can read this by e.g.:
Import["d:/tmp/t.txt", "Table", "FieldSeparators" -> {";"}]
The magic word is "FieldSeparators".
Daniel
Dennis wrote:
> I'm trying to read a csv with mathematicaâ?¦
>
> Now the problem is that my system settings are at ";" as seperator instead of more traditional ",". So the it effectively looks like 1;1;1;1 instead of 1,1,1,1
>
> Normally this makes not difference as in most software you can choose the delimiter/seperator before reading a file, so you pick â??separator = ;â?? or whatever.
>
> With mathematica however I have so far been unable to do this. Now the question of course: how so I change the seperator with mathematica?
>
> Because quite a few files have a â??;â?? separator I would like to find a solution within mathematica instead of changing the system settings.
>
> Cheers,
>
> Dennis
>
- Follow-Ups:
- Re: Re: Reading csv with ;
- From: George Woodrow III <georgevw3@mac.com>
- Re: Re: Reading csv with ;
- From: George Woodrow III <georgevw3@mac.com>
- Re: Re: Reading csv with ;