Convert String Array to Numeric matrix and string array
147 views (last 30 days)
Show older comments
Hi! I have a 3 by 15 string matrix. I wish to extract the first and third row as numbers to be assigned to a numerical matrix, while extracting the second row as a row of strings, which are to be assigned to another matrix.
Here is the info:
data_events=
"1" "60" "" "" "" "" "" "" "" "" "" ""
"-" "" "" "" "" "" "" "" "" "" "" ""
"60" "50" "2" "25" "0" "0.2" "0.2" "10" "1000000000" "100000" "100000" "1000000000"
Columns 13 through 15
"" "" ""
"" "" ""
"100000" "100000" "1080"
The idea is to create a matrix Event_Vals, which consists of the stuff in the first and third rows, while another matrix, Event_Comments is to contain the contents of the second row.
0 Comments
Answers (2)
per isakson
on 30 Jun 2019
Try this
%%
data_events = [
"1" "60" "" "" "" "" "" "" "" "" "" ""
"-" "" "" "" "" "" "" "" "" "" "" ""
"60" "50" "2" "25" "0" "0.2" "0.2" "10" "1000000000" "100000" "100000" "1000000000"
];
%%
Event_Vals = str2double( data_events([1,3],:) );
3 Comments
per isakson
on 30 Jun 2019
+1
I had missed "Unlike the char function, string does not treat numbers as ASCII or Unicode® code points."
dpb
on 30 Jun 2019
Me neither. Having MATLAB act similar to BASIC is not something we're used to...I've yet to play that much with the string class so still discovering such things, too.
dpb
on 30 Jun 2019
EventVals=str2double(data_events(1:2:end,:));
EventCmnt=data_events(2,:);
0 Comments
See Also
Categories
Find more on Data Type Conversion 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!