Re: Reading csv with ;
- To: mathgroup at smc.vnet.net
- Subject: [mg99482] Re: Reading csv with ;
- From: Bill Rowe <readnews at sbcglobal.net>
- Date: Wed, 6 May 2009 05:27:52 -0400 (EDT)
On 5/5/09 at 5:42 AM, detebeest at hotmail.com (Dennis) wrote:
>I'm trying to read a csv with mathematica=C3=A2=C2=80=C5
>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
>=C3=A2=C2=80=C2=9Cseparator = ;=C3=A2=C2=80=C2=9D 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 =C3=A2=C2=80=C2=9C;=C3=A2=C2=80=C2=9D sep=
arator I would like to
>find a solution within mathematica instead of changing the system
>settings.
One way to approach this would be to use Import as follows:
Import[filename, "Table", "FieldSeparators->{";"}]
Search on ref/format/Table in the document center for more information