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