using readtable function except for last five lines from text file

Question

sermet OGUTCU 2021-8-14

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/898302-using-readtable-function-except-for-last-five-lines-from-text-file

评论： sermet OGUTCU 2021-8-15

Coor_2021107_OLK2-ROM2.zip

for i=1:2
line_check{i,:} = regexp(fileread(full_file_name(i,:)),'\n','split');
end_of_header_line(i) = find(contains(line_check{i,:},'++Coordinate')); 
end
for j=1:2
tCOD{j,:}=readtable(full_file_name(j,:),'FileType','text', ...
                                          'headerlines',end_of_header_line(j),'readvariablenames',0);
end

The above codes worked with the attached file without the last five lines. If the last five lines does not deleted, the codes give "All lines of a text file must have the same number of delimiters" error. How I can use readtable without reading the the last five lines from text file?

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

请先登录，再进行评论。

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

Answer 1

Simon Chan 2021-8-14

2
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/898302-using-readtable-function-except-for-last-five-lines-from-text-file#answer_766942

编辑：Simon Chan 2021-8-14

Use your similar method to detect the last line of the valid data and add some import options as follows:

for i=1:2
line_check{i,:} = regexp(fileread(full_file_name(i,:)),'\n','split');
end_of_header_line(i) = find(contains(line_check{i,:},'++Coordinate')); 
end_of_data_line(i) = find(contains(line_check{i,:},'--Coordinate'));           % Added this line
end
%   Add some import options
for j=1:2
    opts = detectImportOptions(fileread(full_file_name(j,:));
    opts.DataLines=[end_of_header_line(j)+1 end_of_data_line(j)-1];             % Valid data line
    %   Following two lines are optional, depends on what format you want
    %opts.Delimiter={' '};          
    %opts.ConsecutiveDelimitersRule='join';
    tCOD{j,:}=readtable(full_file_name(j,:),opts);
end

2 个评论
显示无隐藏无

Simon Chan 2021-8-15

Try the following, also find some typo in my previous code and hence revised as follows:

for i=1:2
    line_check{i,:} = regexp(fileread(full_file_name(i,:)),'\n','split');
    end_of_header_line(i) = find(contains(line_check{i,:},'++Coordinate')); 
    end_of_data_line(i) = find(contains(line_check{i,:},'--Coordinate'));   % Added this line
end
%   Add some import options
for j=1:2
    opts = detectImportOptions(full_file_name(j,:));                        % Revised this line
    opts.DataLines=[end_of_header_line(j)+1 end_of_data_line(j)-1];         % Valid data line
    opts.Delimiter={' '};
    opts.LeadingDelimitersRule='ignore';
    opts.ConsecutiveDelimitersRule='join';
    tCOD{j,:}=readtable(full_file_name(j,:),opts);
    xyz{j,:}=tCOD{j,:}(:,16:18);
end