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: [mg99443] Re: Reading csv with ;
  • From: Valeri Astanoff <astanoff at gmail.com>
  • Date: Wed, 6 May 2009 05:20:35 -0400 (EDT)
  • References: <gtp1h5$k58$1@smc.vnet.net>

On 5 mai, 11:39, Dennis <detebe... at hotmail.com> wrote:
> I'm trying to read a csv with mathematica=85
>
> 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 =93separator = ; 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 =93;=94 separator I would like to find a solution within mathematica instead of changing the system settings.
>
> Cheers,
>
> Dennis

Good day,

My DIY way to do it:

In[1]:= test=Import["test.csv"]
Out[1]= {{1.0;2.0;3.0;4.0},{5.0;6.0;7.0;8.0},{9.0;10.0;11.0;12.0}}

In[2]:= %//FullForm
Out[2]//FullForm= List[List["1.0;2.0;3.0;4.0"],List
["5.0;6.0;7.0;8.0"],List["9.0;10.0;11.0;12.0"]]

In[3]:=  test/.str_String:>
Sequence@@ToExpression@("{"<>StringReplace[str,";"->","]<>"}")
Out[3]= {{1.,2.,3.,4.},{5.,6.,7.,8.},{9.,10.,11.,12.}}

In[4]:= %//FullForm
Out[4]//FullForm= List[List[1.`,2.`,3.`,4.`],List[5.`,6.`,7.`,8.`],List
[9.`,10.`,11.`,12.`]]



  • Prev by Date: Re: defining consecutive variables
  • Next by Date: Re: number of Trangles in a graph-network
  • Previous by thread: Re: Reading csv with ;
  • Next by thread: Re: Re: Reading csv with ;