Turning numbers from string into doubles / into table with doubles
3 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Christian Schumacher
am 10 Jan. 2019
Beantwortet: madhan ravi
am 10 Jan. 2019
Hello,
I have a database which I am trying to convert into Matlab as a table. This generally works really well, but now I am having a problem, which I wasn't able to solve with the Internet.
The database gives me a column with date like this: [21, 22, 34,36]. When I try to convert this via excel-import, as i have done it before, it is only convertable as a string. Doing this, I tried to turn the string arry into cells or doubles with stringsplit or string2double. Both was unsuccessful.
With the function erase, i was able to erase "[" and "]", so i have still "21,22,34,36" left. With the options i mentioned above I am still not able to convert the string to double, the data must be something like this, to use string2double: " '21', '22','34','36' ".
Has anyone an idea?
Thank you for your help,
Kind regards
Christian
0 Kommentare
Akzeptierte Antwort
Weitere Antworten (1)
madhan ravi
am 10 Jan. 2019
a=" '21', '22','34','36' ";
b=strsplit(strrep(a,'''',''),',');
Result=str2double(b)
Gives:
Result =
21 22 34 36
0 Kommentare
Siehe auch
Kategorien
Mehr zu Characters and Strings finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!