textread facing unexpected characters. Gives an error.

1 次查看（过去 30 天）
Theo
Theo 2015-4-23
评论： Theo 2015-4-23
I'm trying to read the following file using textread with the following command [names, types, x, y, answer] = textread('data.txt', ... '%s %f %s %d %d', 'headerlines', 2)
cg00000292 0.826063401 ATP2A1 16 28890100
cg00002426 0.178659348 SLMAP 3 57743543
cg00003994 0.041451237 MEOX2 7 15725862
cg00005847 0.381918846 HOXD3 2 177029073
cg00006414 NA ZNF425;ZNF398 7 148822837
cg00007981 0.037822681 PANX1 11 93862594
however it gives me the following error
Trouble reading floating point number from file (row 5, field 2) ==> NA ZNF425;ZNF398 7
148822837\n
I understand that textread is expecting a float but reaches the NA and gives the error, now my question is how to tell matlab to replace the unexpected with NaN and proceed instead of breaking the execution.
Help is appreciated :)

请先登录，再回答此问题。

采纳的回答

per isakson
per isakson 2015-4-23
编辑：per isakson 2015-4-23
Try
>> cac = cssm
cac =
{6x1 cell} [6x1 double] {6x1 cell} [6x1 int32] [6x1 int32]
where
function cac = cssm()
fid = fopen( 'cssm.txt' );
cac = textscan( fid, '%s%f%s%d%d', 'Delimiter','\t', 'TreatAsEmpty','NA' );
fclose( fid );
end
and cssm.txt contains the sample data of the question

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Data Import and Export 的更多信息

标签

产品

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by