MATLAB: Reading and processing text file

text file reading

Hi,

This probably a simple question for the expert but I am swamped by the too many options. I have a text file (a sample is attached here). The file starts with header where the first line is named as structure and this line is followed by few more text lines and then three columns header and the data. After this data, another line (named as structure) starts and the same continues for couple of more structures. I want to read this file and write it as excel file where each structure start firsts and read data and then the next structure starts in parallel with first one. I have shown it in the excell file attached here. Since there are so many data and couple of structures it would be great if I can write a code. I vastly appreciate any help. I already tried with textscan but could not get it working.

Best Answer

While it's certainly possible to read it the file in matlab and write it to excel the way you want, if it's the only thing you do I don't see the point.

Just open the text file in excel and the importer will do exactly what you want.

Now, if you do insist on doing it matlab:

excel = actxserver('Excel.Application');
wb = excel.Workbooks.OpenText('test_rafiq.txt'); Just call excel text importer with default values
wb.SaveAs('test_rafiq.xlsx');
wb.Close;
excel.Quit;
delete(excel);

Related Solutions

MATLAB: Trying to delete lines that start with an alphabet on a text file

Use fopen, fgetl, fclose to read your file into a cell array and discard the lines you don't want. Or if you want to write a new file, use fopen, fprintf, fclose and write as your read:

fidi = fopen('somefile.txt', 'rt');
fido = fopen('newfile.txt', 'wt');
tline = fgetl(fidi);
while ischar(tline)
  if ~isempty(tline) && tline(1) >= '0' && tline(1) <= '9'
    %line to keep
    fprintf(fido, '%s\n', tline);
  end
  tline = fgetl(fidi);
end
fclose(fidi);
fclose(fido);

edit: forgot to read the next line!

MATLAB: Behavior of for loop with strings of chars

you will probably want to switch from a vector to a cell array of character vectors

patterns = {'=A=' '=B=' '=C='};
for i = 1:length(patterns)
[starts, ends] = regexp(line, patterns{i});
end

or better yet like Stephen Cobeldick mentioned, send the cell array over to regexp

patterns = {'=A=' '=B=' '=C='};
[starts, ends] = regexp(line, patterns);

or just put it all in a single pattern

[starts, ends] = regexp(line, '=[ABC]=');

Best Answer

Related Solutions

MATLAB: Trying to delete lines that start with an alphabet on a text file

MATLAB: Behavior of for loop with strings of chars

Related Question