MATLAB Central Newsreader - Decimal Separator

Decimal Separator

Ellen Arens — Fri, 21 Nov 2008 16:49:03 -0500

How can I import numeric data that uses a comma as a decimal separator? For example, a table of 640 by 480 numberic valves.

Re: Decimal Separator

Andres — Fri, 21 Nov 2008 20:47:02 -0500

"Ellen Arens" <ellen.e.arens@nasa.gov> wrote in message <gg6opu$1i2$1@fred.mathworks.com>...
> How can I import numeric data that uses a comma as a decimal separator? For example, a table of 640 by 480 numberic valves.

You want to import the table from an ascii file?
Try out txt2mat from the matlab central file exchange. If the file structure is not too weird, just

A=txt2mat('myfile.txt')

will do.
Hth
Andres

Re: Decimal Separator

Rune Allnor — Fri, 21 Nov 2008 23:41:27 -0500

On 21 Nov, 17:49, "Ellen Arens" <ellen.e.ar...@nasa.gov> wrote:
> How can I import numeric data that uses a comma as a decimal separator? =
=A0For example, a table of 640 by 480 numberic valves.

The general idea would be to read a full line, replace
commas by dots and then convert to numbers. Something
like (not tested!):

%%%%%%%%%%%%%%%%%%%%%%%%%%%%
fid =3D fopen('file.txt');
A =3D[];
while(~feof(fid))
    s =3D fgetl(fid); % Read line from file
    cidx =3D find(s=3D=3D','); % Find all commas...
    s(cidx)=3D'.'; % ...and replace with dots
    a=3Dsscanf('%f',s,inf); % Read in as numbers
    A =3D [A;a']; % Append to result matrix
end
fclose(fid);
%%%%%%%%%%%%%%%%%%%%%%%%%%%%

Rune