I want to export data to txt file in Loop

Question

The boy 2023-2-1

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1904270-i-want-to-export-data-to-txt-file-in-loop

评论： The boy 2023-2-3

files = dir('*.txt');
N =length(files);
for i=1:N
    data = readtable(files(i).name);
    data = removevars(data, {'Var9','Var10'});
    % save to txt file
    newtxt = table2cell(finalfile(:,1:9));
    writecell(newtxt,'newfile.txt','Delimiter','tab');
    type newfile.txt
    
end

*** my code above is try to remove some columm in a txt file, I have 30 txt file like that need to work in a LOOP.

Everytime I write the txt file, the new file is overwritten in the same file name, I do not know how to write the txt file with using LOOP . Please help me to fix the code again. Thank you

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

请先登录，再进行评论。

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

Answer 1

Stephen23 2023-2-1

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1904270-i-want-to-export-data-to-txt-file-in-loop#answer_1161030

在 MATLAB Online 中打开

P = 'absolute or relative path to where the files are saved';
S = dir(fullfile(P,'*.txt'));
for k = 1:numel(S)
    F = fullfile(S(k).folder,S(k).name);
    D = readtable(F);
    D = removevars(D, {'Var9','Var10'});
    % new filename
    [~,F,E] = fileparts(S(k).name);
    F = sprintf('%s_new%s',F,E);
    % save to txt file
    newtxt = table2cell(finalfile(:,1:9));
    writecell(newtxt,F,'Delimiter','tab');
end

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

The boy 2023-2-3

Thanks Stephen23, I learned it . Your code work well!

请先登录，再进行评论。

Answer 2

Jeremy Hughes 2023-2-2

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1904270-i-want-to-export-data-to-txt-file-in-loop#answer_1162336

在 MATLAB Online 中打开

If you want to write the data to one file, this should work

for i=1:N
    data = readtable(files(i).name);
    % Assuming you're removing data you don't need (and that Var9 Var10 are # 9 and 10), this is the most concise way.
    writetable(data(:,1:8),'newfile.txt','Delimiter','\t','WriteMode','append');
end

If you want do write to different files:

mkdir("newplace")
for i=1:N
    data = readtable(files(i).name);
    newname = fullfile("./newplace","new_"+files(i).name);
    writetable(data(:,1:8),newname,'Delimiter','\t');
end