Re: Importing data with comma as decimal separator
- To: mathgroup at smc.vnet.net
- Subject: [mg98130] Re: Importing data with comma as decimal separator
- From: Bob F <deepyogurt at gmail.com>
- Date: Tue, 31 Mar 2009 04:16:47 -0500 (EST)
- References: <gqq3sb$7mt$1@smc.vnet.net>
On Mar 30, 3:37 am, Dom <Domagoj.Pavi... at gmail.com> wrote:
> 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 might try something like this:
str = OpenRead["testcomma.txt"];
Read[str, {Record, Record, Record, Record, Record, Record, Record,
Record, Record, Record, Record, Record}];
datac = ReadList[
str, {Number, Character, Number, Character, Number, Character,
Number}];
Close[str];
For[j = 1, j < Length[datac] + 1, j++, {
a = Part[datac[[j]], 1];
b = Part[datac[[j]], 3];
c = Part[datac[[j]], 5];
d = Part[datac[[j]], 7];
xx[j] = a + b/(10.^(StringLength[ToString[b]])),
yy[j] = c + d/(10.^(StringLength[ToString[d]]));
}]
This assumes the data file has 12 records/lines to ignore, then an
indeterminate amount of data records that have the form (the white
space is a TAB character, ASCII 009)
xxxx,yyyy xxxxxxx,yyy
and you wanted the data to look like
xxxx.yyyy xxxxxxx.yyy
I am sure there are lots of ways to do this, so take this into
consideration, when you get 10 different suggestions. HTH.
-Bob