outputfile name using the inputfile name

Question

WENDILYN GUIDOTTI 2022-10-18

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1830003-outputfile-name-using-the-inputfile-name

评论： WENDILYN GUIDOTTI 2022-10-18

I am trying to have the input file name pulled into the output file name in an excel format, and I added a letter so they can exist in the same folder. However, it is taking the file names with similar starting numbers and combining them even thought the rest of the file name is different. So if there are three files that start with 2022 I only get one excel file 2022 with the last file name in the chain. What am I missing?

EX:

TKL = rmfield(tkl, 'field_');

TK = structure2table(TKL);

cd = 'C: folderlocation';

inputfile = filename(kk).name;

[~,fname] = fileparts(inputfile);

outputfile = sprintf('%s_D.xlsx',fname);

writetable(TK,outputfile,'sheet',1);

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

请先登录，再进行评论。

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

Answer 1

Image Analyst 2022-10-18

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1830003-outputfile-name-using-the-inputfile-name#answer_1078113

在 MATLAB Online 中打开

You need to have a loop over all the files

TKL = rmfield(tkl, 'field_');
TK = structure2table(TKL);
folder = 'C:\folderlocation';
filePattern = fullfile(folder, '/2022*.xlsx');
fileList = dir(filePattern);
numFiles = numel(fileList);
fprintf('Found %d files matching the pattern "%s".\n', numFiles, filePattern)
% Copy TK into the same number of new files having the same name
% but with a "_D" suffix.
for k = 1 : numFiles
    fullInputFileName = fullfile(fileList(k).folder, fileList(k).name);
    % Prepare the output file name.
    [~, baseFileNameNoExt, ext] = fileparts(fullInputFileName);
    baseOutputFileName = sprintf('%s_D.xlsx', baseFileNameNoExt);
    fullOutputFileName = fullfile(folder, baseOutputFileName);
    writetable(TK, fullOutputFileName, 'Sheet', 1);
end