How to extract time and date data from huge text file?

Question

Nikhil 2016-1-29

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/265679-how-to-extract-time-and-date-data-from-huge-text-file

回答： John BG 2016-1-29

采纳的回答： John BG

Nikhil.txt

在 MATLAB Online 中打开

Dear all,

I am working on one big data science project. I need to extract data from one text file into separate columns of Matlab variable. I have attached smaller portion of the data along with this message. Can anybody please tell me where am I going wrong in my code for extracting data from text file? Thank you in advance, My MATLAB code is as follows:

fid = fopen('Nikhil.txt','r');
iread=0; icount = 0;
while(iread~=1)
    icount=icount+1;
    tline=fgetl(fid);
corr1=strfind(tline,'Date;Time;Global_active_power;Global_reactive_power;Voltage;Global_intensity;Sub_metering_1;Sub_metering_2;Sub_metering_3');
    if(corr1~=0)
        sizeA= [9 Inf];
        [strdat, count]=fscanf(fid,['%D %D %g %g %g %g %g %g %g'],sizeA);
        iread=iread+1;
    end;
end;
    %strdat=strdat';
    fclose(fid);
    n=length(strdat);
    strdat

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

John BG 2016-1-29

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/265679-how-to-extract-time-and-date-data-from-huge-text-file#answer_207794

在 MATLAB Online 中打开

your data file has a format that allows to import text without while fgetl strfind and fscanf

filename='Nikhil.txt'
delimiter = ';';
startRow = 2;
endRow = 50;
formatSpec2='%s %s %s %s %s %s %s %s %s';
fileID = fopen('DataSample.txt','r');
dataArray = textscan(fileID, formatSpec2, endRow-startRow+1, 'Delimiter', delimiter, 'MultipleDelimsAsOne', true, 'HeaderLines', startRow-1, 'ReturnOnError', false);