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.

https://dl.dropbox.com/u/31561571/Test.txt

Answer 1

[Matt Fig]

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

[Debanjan Goswami]

cool! thanks a lot

Answer 2

[Abirami M]

https://archive.ics.uci.edu/ml/datasets/Health+News+in+Twitter#

Use this Url and how to read and preprocess this kind of text data in matlab.