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

19 views (last 30 days)
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.

Accepted Answer

madhan ravi
madhan ravi on 14 Nov 2018
Edited: madhan ravi on 14 Nov 2018
fid=fopen('Example_of_input3.txt');
f=textscan(fid,'%s', 'delimiter','\n');
fclose(fid);
celldisp(f)
  4 Comments
Danupon Subanapong
Danupon Subanapong on 14 Nov 2018
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
madhan ravi on 14 Nov 2018
Anytime :) , see my previous comment just use indexing loop is not needed , search indexing cell array in internet and read slowly you will understand

Sign in to comment.

More Answers (0)

Categories

Find more on Data Type Conversion in Help Center and File Exchange

Products


Release

R2018a

Community Treasure Hunt

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

Start Hunting!