Cell array to ordinary array. cell2mat

Hi.

I have got a cell array C, but I would like to convert it to a ordinary array. When I try do it with the function cell2mat I get a 1 by 1 matrix with in spot 1,1 all numbers seperated by comma's. (probably because the array originally came from a .cvs file.) How to I get a 1 by 7 ordinary array?

C = {'0,800385595', '16,75872765', '-11,99131211', '3,884404324', ...
 '2,127166729', '0,917013004', '9,531417436'}

Many Thanks, Daan

Answer 1

[Stephen23]

You can use str2double inside cellfun, like this:

>> C = {'0,800385595', '16,75872765', '-11,99131211', '3,884404324', '2,127166729', '0,917013004', '9,531417436'};
>> N = cellfun(@str2double,strrep(C,',','.'))

Also note that if the original data is in a .csv file and uses a decimal point (not a comma), then this data can be read as directly as numeric values anyway, without requiring conversion to numeric after reading them into MATLAB. You can have a look at textscan, or all of the other text-file reading functions.

[Jan]

This is not spam, of course. When I hit the "This is not spam" button, I get an error message, that "something went wrong". Strange. Ah, most likely someone else hit this button before already.

Answer 2

[Jan]

It is fast to concatenate the strings and parse them afterwards at once:

C = {'0,800385595', '16,75872765', '-11,99131211', '3,884404324', ...
     '2,127166729', '0,917013004', '9,531417436'};
C = strrep(C, ',', '.');  % Dots as decimal separator!!!
S = sprintf('%s*', C{:});
D = sscanf(S, '%f*');