Mathematica 9 is now available
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 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

> 




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