Extracting numbers from array of cells
40 次查看(过去 30 天)
显示 更早的评论
Hello,
when reading data from a log file, I use "textscan", which yields an array of cells, e.g.
my_data_string = {'1.11'; '2.22'; '3.33'};
Now I want to convert all strings simultaneously to numbers.
How can I achieve this without using a for loop?
If I use the following approach,
my_data_number = textscan([my_data_string{:}], '%f'); % vector bracket causes "faulty" combined string
my_data_number = my_data_number{1,1}; % conversion of cell array to number array
my_data_number =
1.1120
0.2230
0.3300
the numbers are read incorrect because of the use of vector brackets inside the textscan command. This causes the strings to be all concanated without break, which then messes up the textscan command.
[my_data_string{:}]
ans =
'1.112.223.33'
I experimented with different brackets and vector notations, but so far, I could not find a solution. I am not necessarily fixed on using textscan, but I cannot use loops.
Thanks in advance for any advice,
DH
1 个评论
Stephen23
2019-7-10
Why not simply:
>> my_data_string = {'1.11'; '2.22'; '3.33'};
>> num_vec = str2double(my_data_string)
num_vec =
1.11
2.22
3.33
?
采纳的回答
madhan ravi
2019-7-9
V = regexp(my_data_string,'\d+[\.]?\d*','match','once');
Wanted = str2double(V)
% or
Wanted = str2double(my_data_string) % if the data appears exactly like shown in the example
4 个评论
Stephen23
2019-7-10
No need for the square brackets:
'-?\d+\.?\d*'
Optional positive sign:
'[+-]?\d+\.?\d*'
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Large Files and Big Data 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!