Extract data from HTML Table

Question

Marcus Glover 2021-2-6

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/737692-extract-data-from-html-table

回答： Mathieu NOE 2021-3-5

html_table.txt

I have a HTML file (attached at .txt) with a table of data I would like to extract. I found the FEX file htmltabletocell, but I don't thtink that will work for me as my table has several repetitions of simalar data blocks with the same initial string.

Ultimately, I would like to extract the data values from only a few of the selected fields below (for example Date/Time and Diagnostic Reason only)

Any help is much appreciated.

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

请先登录，再进行评论。

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

Answer 1

Mathieu NOE 2021-3-5

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/737692-extract-data-from-html-table#answer_640071

在 MATLAB Online 中打开

hello Marcus

here you are, simple code shipset :

Filename = 'html_table.txt';
[myDate, myDiagnostic] = extract_data(Filename)
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
function [myDate, myDiagnostic] = extract_data(Filename)
fid = fopen(Filename);
tline = fgetl(fid);
% initialization
k = 0;
p = 0;
q = 0;
k_parameter = 0;
q_parameter = 0;
myDate = [];
myDiagnostic = [];
while ischar(tline)
    
    k = k+1;    % loop over line index
    
   % retrieve line Date/Time
    if contains(tline,'Date/Time')   
        k_parameter = k;
        p = p+1;
    end
    if p>0 & k == k_parameter + 3
        myDate = [myDate; cellstr(tline)];
    end
   
   % retrieve line Date/Time
    if contains(tline,'Diagnostic')   
        q_parameter = k;
        q = q+1;
    end
    if q>0 & k == q_parameter + 3
        myDiagnostic = [myDiagnostic; cellstr(tline)];
    end
    
tline = fgetl(fid);
end
fclose(fid);
end