How to build a num array

Hello,

I have following situation, from a database I got following table:

table (1,1) = {'[-7.045866760858189, -6.961728203539678, -6.378816032116447]'}

How can I create a num table with a array of each value?

Tablenew (1,1) = -7.045866760858189

Tablenew (1,2) = -6.961728203539678

...

Answer 1

[Walter Roberson]

The below solution assumes that there are the same number of entries in each row, but does not depend upon there being exactly 3.

format long g
Table(:,1)  = {'[-7.045866760858189, -6.961728203539678, -6.378816032116447]';
               '[-3.13423, -5.5512435, -99.999999999]'}

Table = 2x1 cell array
    {'[-7.045866760858189, -6.961728203539678, -6.378816032116447]'}
    {'[-3.13423, -5.5512435, -99.999999999]'                       }

Tablenew = cell2mat(cellfun(@str2num, Table(:,1), 'uniform', 0))

Tablenew = 2×3

-7.04586676085819 -6.96172820353968 -6.37881603211645 -3.13423 -5.5512435 -99.999999999

Tthe str2num() will eval() each line, and if a line happened to contain something like 'rmdir(".")' then it would be happy to delete your directory.

The below solution assumes that there are exactly 3. It is a more secure solution. It could be generalized with not a lot work for the case where the number per line was consistent but not necessarily 3.

cell2mat(textscan(strjoin(Table(:,1)), '[%f,%f,%f]'))

ans = 2×3

-7.04586676085819 -6.96172820353968 -6.37881603211645 -3.13423 -5.5512435 -99.999999999