string inside a table
显示 更早的评论
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 个评论
Jan
2017-9-20
Before we can suggest, how to solve this, we need to know, what you want to appear instead of the '-'. Is NaN okay?
Walter Roberson
2017-9-20
Is it possible that the original data contained "- 20" with a space between the "-" and the "20" ?
eric capnu
2017-9-20
采纳的回答
Walter Roberson
2017-9-20
YourTable.column1 = str2double(YourTable.column1);
更多回答（1 个）
Jeremy Hughes
2017-9-21
Try:
>> T = readtable(filename,'TreatAsEmpty',{'-'})
Jeremy
类别
在 帮助中心 和 File Exchange 中查找有关 Tables 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
