Read text file containing string and numeric data

I would like read the following text file that has column values with string and numeric data. Problem is the numeric column is mixed with 'N/A'. After reading, I like to use data from column 8 and 11. I'm using R2010b.

 采纳的回答

fid = fopen('Test.txt');
C = textscan(fid,repmat('%s',1,19),'Headerlines',1)
fclose(fid)
HeadDiam = str2double(C{8});
TYPE = C{11};
Note that when using STR2DOUBLE, those N/As are converted to NaNs

更多回答(1 个)

类别

帮助中心File Exchange 中查找有关 Data Type Conversion 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by