Textscanning and exporting several text files

Question

Liisa 2012-1-27

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/27212-textscanning-and-exporting-several-text-files

Hi,

I'm trying to combine data from several text files (file1, file2, etc.) and export the data into one file (or matrix) after textscan loops and some basic calculation. I have only managed to export from the last loop (overwrites?). My code so far:

d = dir('*.txt');
for n=1:numel(d)
    filepath=['..\matlab_testing\'];      
    filena=['file' num2str(n) '.txt'];    
[filepath filena];
if exist([filepath filena])
  fid=fopen([filepath filena],'rt');
  out = [];
row = fgetl(fid);    
data = textscan(fid, '%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f');
out = [out;cell2mat(data)];
end 
idx1 =out(:,3) == 100;
h1 = out(idx1,:);  
xlswrite('h_ka_txt.xls',h1,'klo1', 'A2'); %works, but contains data only from the last file

How to continue so that I have one matrix that contains data from all the files?

Also, is the better way to textscan than (fid, '%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f'), if file has several hundred columns?

Thank you, all the help is greatly appreciated, Liisa

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

请先登录，再进行评论。

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

Answer 1

Chandra Kurniawan 2012-1-27

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/27212-textscanning-and-exporting-several-text-files#answer_35412

在 MATLAB Online 中打开

Hi, Liisa

Look at line

data = textscan(fid, '%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f');

Did you mean

data = textscan(row, '%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f');

And you can replace these lines

filepath=['..\matlab_testing\'];      
filena=['file' num2str(n) '.txt'];    
[filepath filena];
if exist([filepath filena])
fid=fopen([filepath filena],'rt');

with

fid = fopen(d(n).name,'rt');

Also at line

out = [];

should be placed outside the loop.

And about

data = textscan(row,'%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f');
out = [out; cell2mat(data)];

Can be replaced with

data = str2num(row);
out = [out; data];

So, the complete code is :

d = dir('*.txt');
out = [];
for n = 1 : numel(d)
    fid = fopen(d(n).name,'rt');    
    row = fgetl(fid);        
    %data = textscan(row,'%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f');
    data = str2num(row);
    %out = [out; cell2mat(data)];
    out = [out; data];
end