How to import data with string, missing data,and numeric values?

Hi!! I would like to ask for your help. I have to a number of import text data. Inside these text files, there are strings, numeric values, and missing data. I have been seeking for how to import these files. I tried importdata, but it only imports data from row no.1 to the missing data row. I will attach the example of input file as well. Please check it.

Answer 1

[madhan ravi]

fid=fopen('Example_of_input3.txt');
f=textscan(fid,'%s', 'delimiter','\n');
fclose(fid);
celldisp(f)

[Danupon Subanapong]

Thank you so much for your answer. It works. However, I have one more question. How to extract numeric array and strings from f?

[madhan ravi]

 
f{1}{1:3} %others
f{1}{4:end} %numeric

Anytime :) make sure to accept the answer if you got the answer to your question

[Danupon Subanapong]

Thank you so much. Your answer is very helpful. I have one last question. I have been trying to convert the character array f{1}{4:end} to numeric array. I try to use for loop as shown below. But it takes very long time to process. Can you please suggest some alternative for faster solution?

A=zeros(12000,5);
for i=4:end
A(i,:)=str2num(string(f{1}{i})
end

[madhan ravi]

Anytime :) , see my previous comment just use indexing loop is not needed , search indexing cell array in internet and read slowly you will understand