fid = fopen('data1.txt','r');
strData = textscan(fid,'%s','Delimiter','\r\n');
strData = strData{1};
fclose(fid);
idx1 = cellfun(@isempty,strData);
idx2 = contains(strData,'--');
strData = strData(~idx1 & ~idx2);
strData = replace(strData,'#',' #');
strData = regexprep(strData,'\s{3,}',' ');
outData = cell(size(strData,1),6);
for kk = 1:size(strData,1)
c = strsplit(strData{kk},' ');
outData(kk,[1:numel(c)-1, end]) = c;
end
writecell(outData,'result.xlsx');
Best Answer