Re: Importing data with comma as decimal separator
- To: mathgroup at smc.vnet.net
- Subject: [mg98148] Re: Importing data with comma as decimal separator
- From: annetts729 <davidannetts at aapt.net.au>
- Date: Tue, 31 Mar 2009 04:20:08 -0500 (EST)
- References: <gqq3sb$7mt$1@smc.vnet.net>
Hi Dom, > I would like to import two-column numerical data in which comma is > used as decimal separator. The first 12 lines of the file is header, > followed by two tab-separated columns of numbers. > How I can do this in Mathematica 6.0? > Thanks. You can use Import. Something like the following sequence might work for you. idata = Import["Test.txt", "Table"]; (* import all the data as strings -- the default for *.txt *) sdata = Select[idata, UnsameQ[#[[1]], "#"] &] (* drop all header lines -- sdata = Drop[idata, {1, 12}] can also work *) ddata = StringReplace[#, {"," -> "."}] & /@ sdata (* replace our commas with decimal points *) ddata = Map[ToExpression, ddata] (* ... and convert everything to expressions -- reals *) Regards, Dave.