string inside a table
2 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
eric capnu
am 20 Sep. 2017
Beantwortet: Jeremy Hughes
am 21 Sep. 2017
hi guys:
i export csv files from an url by using urlwrite and readtable commands. the resulting table is (or should be) composed of numbers, somehow some table cells has the value '-'. Because of this, the whole column containing that string '-' become into string values, like this:
column1 column2
------- -------
'12' 34
'10' 12
'-' 20
'1.1' 13.1
'34.9' 66
is there a way to avoid it? i mean, the whole table as numbers...
thanks
3 Kommentare
Walter Roberson
am 20 Sep. 2017
Is it possible that the original data contained "- 20" with a space between the "-" and the "20" ?
Akzeptierte Antwort
Weitere Antworten (1)
Jeremy Hughes
am 21 Sep. 2017
Try:
>> T = readtable(filename,'TreatAsEmpty',{'-'})
Jeremy
0 Kommentare
Siehe auch
Kategorien
Mehr zu Tables 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!