dear all,
in one folder, for example there are three excel files, named 1.xlsx , 2.xlsx and master.xlsx.
i used directory.getfiles(path, “*.xlsx”) to to get a string but i dont not want contains the master.xlsx just 1.xlsx and 2.xlsx , how could i achieve this function?
anybody could give a guide ?
thanks a lot in advance
@Chris-Yiwei even though you get all those files you can filter by using if condition inside the for each loop,say for example as you said there are three files out of that you want only two,so inside the for each loop you can give if condition like item which contains master if it finds it went to then if not else,so to the else condition other two files will come.have a try this
Try this expression:
directory.getfiles(path, “?.xlsx”)
Just replace wild card star “*” with question mark ? And then try.
i used this directory.getfiles() it will collect all the xlsx files, but i want to excluse one special excel file
Just try the above expression and it will skip master file and will give remaining files.
i used directory.getfiles(path, “master.xlsx”) the output file is only master.xlsx but i do not need master.xlsx just need 1.xlsx , 2.xlsx
i print the result , it is empty directory.getfiles(path, “?.xlsx”)
Hi
Kindly folllow the below steps that could help you resolve this
—use as assign activity like this
Out_Filepatharray = Directory.GetFiles(“yourfolderpath”,”*.xlsx”).Where(name => !name.EndsWith(“Master.xlsx”))
Or by this mean as well @Chris-Yiwei
Out_Filepatharray = Directory.GetFiles(“yourfolderpath”,”*.xlsx”)
Out_filesToExclude = Directory.GetFiles(“yourfolderpath",”*.xlsx");
Out_wantedFiles = Filepatharray.Except(Out_filesToExclude);
Cheers @Chris-Yiwei
@Chris-Yiwei
Were we able to get the correct files
Cheers
what is the type of variable Out_Filepatharray , Out_filesToExclude and Out_wantedFiles.
i use this approache , compile error
All should be string array
Do we need to Assign 3 activity??
Hi
Welcome to uipath community
Kindly come again
I didn’t get that
Cheers @ViswanathanAM
Thank you for your warm welcome !!
do i need to create 3 assign activity??
Out_Filepatharray = Directory.GetFiles(“yourfolderpath”,”*.xlsx”)
Out_filesToExclude = Directory.GetFiles(“yourfolderpath",”*.xlsx");
Out_wantedFiles = Filepatharray.Except(Out_filesToExclude);
i tried as per the above but i am getting error message !!
could you pelase share your xmal. file. so that i can easily verify with your assistance 
shot for your reference.
