Extracting numbers from array of cells
43 views (last 30 days)
Show older comments
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 Comment
Stephen23
on 10 Jul 2019
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
?
Accepted Answer
madhan ravi
on 9 Jul 2019
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 Comments
Stephen23
on 10 Jul 2019
No need for the square brackets:
'-?\d+\.?\d*'
Optional positive sign:
'[+-]?\d+\.?\d*'
More Answers (0)
See Also
Categories
Find more on Logical in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!