Text file has headers that are 2X4 and are repeated randomly within the data.

Question

isamh 2020-2-12

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/505175-text-file-has-headers-that-are-2x4-and-are-repeated-randomly-within-the-data

回答： TADA 2020-2-12

采纳的回答： TADA

txt file is:

R E V D

ms km/h km/h -

689427 0.0 0.00 0.0000

689527 0.0 0.00 0.0000

689627 0.0 0.00 0.0000

689727 0.0 0.00 0.0000

689827 0.0 0.00 0.0000

689927 0.0 0.00 0.0000

690027 0.0 0.00 0.0000

690127 0.0 0.00 0.0000

690227 0.0 0.00 0.0000

headers are repeated randomly across the numerical data. I want to ignore the headers when ever they show up. how would I do that?

the TXT file is about 100000 rows down and 4 columns.

my code is:

result = [];

tic

fid=fopen('MCT_Data.txt');

while 1

tline = fgetl(fid);

if ~ischar(tline), break, end

celldata = textscan(tline,'%f %f %f %f %f %f');

matdata = cell2mat(celldata);

% match fails for text lines, textscan returns empty cells

result = [result ; matdata];

end

toc

fclose(fid);

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

请先登录，再进行评论。

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

Answer 1

TADA 2020-2-12

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/505175-text-file-has-headers-that-are-2x4-and-are-repeated-randomly-within-the-data#answer_415310

在 MATLAB Online 中打开

str = fileread('MCT_Data.txt');
nums = cellfun(@str2double, regexp(str, '([\d.,]+)', 'match'));
x = reshape(nums, 4, [])'

x =
      689427           0           0           0
      689527           0           0           0
      689627           0           0           0
      689727           0           0           0
      689827           0           0           0
      689927           0           0           0
      690027           0           0           0
      690127           0           0           0
      690227           0           0           0