How to skip temporary files in a folder

I want to have matlab skip the tempoary excel files when grabbing the files from a folder and copying it to another.

This is the code I currently have

file1=flexdir(fullfile(folder1,['\*',ext]))';

for fileindex=1:size(file1,1)

fname1=files1{fileindex};

[~,fname,fext]=fileparts(fname1);

fname2=flexdir(fullfile(folder2,[fname fext]));

copyfile(fname1, finalpath);

end

I think I need to add something like but not sure where

filelist = filelist(~startsWith({filelist.name}, '~$''));

Also how do I add '_new' at the end of the new file name?

Answer 1

[Image Analyst]

Try this

folder1 = pwd;
folder2 = fullfile(pwd, 'Copied Files');
if ~isfolder(folder2)
    mkdir(folder2);
end
ext = '.csv';
filePattern = fullfile(folder1, ['*', ext]);
fileList = dir(filePattern);
for fileindex = 1 : numel(fileList)
    % Skip file starting with ~
    if startsWith(fileList(fileindex).name, '~')
        continue;
    end
    sourceFileName = fullfile(fileList(fileindex).folder, fileList(fileindex).name);
    [~,fname,fext]=fileparts(sourceFileName);
    destinationFileName = fullfile(folder2,[fname fext]);
    copyfile(sourceFileName, destinationFileName);
end

[Emily]

It doesn't seem like it's copying the tempoary files but when I do the code below on the new copied files folder, it still shows tempoary files. Maybe someone is else is using the folder as well.

newfiles=flexdir(fullfile(folder2,['\*'])

Is there a way to have newfiles = non tempoary files only?

[Image Analyst]

Maybe the files were already there. Try printing out each file as it gets copied and see if there are any starting with a tilde (there should NOT be)

folder1 = pwd;
folder2 = fullfile(pwd, 'Copied Files');
if ~isfolder(folder2)
    mkdir(folder2);
end
ext = '.csv';
filePattern = fullfile(folder1, ['*', ext]);
fileList = dir(filePattern);
for fileindex = 1 : numel(fileList)
    % Skip file starting with ~
    if startsWith(fileList(fileindex).name, '~')
        continue;
    end
    % Prepare source filename.
    sourceFileName = fullfile(fileList(fileindex).folder, fileList(fileindex).name);
    % Prepare destination filename.
    [~,fname,fext]=fileparts(sourceFileName);
    destinationFileName = fullfile(folder2,[fname fext]);
    % Print out what is getting copied.
    fprintf('Copying "%s"\n      to "%s".\n', sourceFileName, destinationFileName)
    % Do the copy.
    copyfile(sourceFileName, destinationFileName);
end

What is flexdir?

[Emily]

Hi, I was able to take your input to account and currently have this.

Right now this is working except the one of the file it is supposed to copy over.

It is able to make the copy of the file but when I try to open the excel file it is all grayed out for me.

The original file looks normal so I'm not sure what's wrong.

function excelcopy(folder1, folder2)

if ~exist('ext','var')|| ~(strcmp(ext, 'xlsx') || strcmp(ext,'.xls'))

ext = 'xlsx'

end

filePattern = fullfile(folder1, ['*', ext]);

fileList = dir(filePattern);

for fileindex = 1 : numel(fileList)

% Skip file starting with ~

if startsWith(fileList(fileindex).name, '~')

continue;

end

% Prepare source filename.

sourceFileName = fullfile(fileList(fileindex).folder, fileList(fileindex).name);

% Prepare destination filename.

[~,fname,fext]=fileparts(sourceFileName);

destinationFileName = fullfile(folder2,[fname fext]);

% Print out what is getting copied.

fprintf('Copying "%s"\n to "%s".\n', sourceFileName, destinationFileName)

% Do the copy.

copyfile(sourceFileName, destinationFileName);

end

[Image Analyst]

Why are you doing this:

if ~exist('ext','var')|| ~(strcmp(ext, 'xlsx') || strcmp(ext,'.xls'))
    ext = 'xlsx' 
end 
filePattern = fullfile(folder1, ['*', ext]);

? ext will not exist at that point because it's not passed in to the function.

It should be

filePattern = fullfile(folder1, '*.xls*');