Services & Resources / Wolfram Forums / MathGroup Archive

MathGroup Archive 2009

[Date Index] [Thread Index] [Author Index]

Search the Archive

Re: Reading csv with ;

  • To: mathgroup at
  • Subject: [mg99482] Re: Reading csv with ;
  • From: Bill Rowe <readnews at>
  • Date: Wed, 6 May 2009 05:27:52 -0400 (EDT)

On 5/5/09 at 5:42 AM, detebeest at (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

>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

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

  • Prev by Date: Re: Reading csv with ;
  • Next by Date: Re: defining consecutive variables
  • Previous by thread: Re: Re: Reading csv with ;
  • Next by thread: Re: Reading csv with ;