Compare folder file names with excel data

[indrajit.shah (iamvicky)]

Hi there,

I am stuck at a scenario -
I have an excel file with file names and have to compare the names with a folder containing file, If the file is present then delete it and only keep the files which name is not present in the excel list.

@ppr - can this be done with LINQ?

[ppr (Peter Preuss)]

@indrajit.shah

can this be done with LINQ?

we can at least involve LINQ, if we want to

@indrajit.shah

If the file is present then delete it

more sharp to define - what, where to delete (file on filesystem, row in excel)

@indrajit.shah

only keep the files which name is not present in the excel list.

some hint for the above requirement part.

Find some starter help

Assign Activity:
arrExcelFileNames | String Array =

YourDataTableVar.AsEnumerable.Select(Function (x) x(YourColNameOrIndex).toString.ToUpper.Trim).toArray

Assign Activity:
arrPresentFileNames | String Array =
new DirectoryInfo(YourFolderPath).GetFiles().Select(Function (x) x.Name.ToUpper).toArray

Assign Activity:
arrFileFoundAndNotInExcel |String Array =
arrPresentFileNames.Except(arrExcelFileNames).toArray

As usual, we can do RnD / prototyping within the immediate panel:
Understanding the 6 Debugging Panels of UiPath in the easiest way possible! - News / Tutorials - UiPath Community Forum

And

[CheatSheet] - Filesystem APIs - News / Tutorials - UiPath Community Forum

[indrajit.shah (iamvicky)]

@ppr

more sharp to define - what, where to delete (file on filesystem, row in excel)

deleting it from the FileSystem, its about

If the filename is present in the excel file then delete the file from the folder

[ppr (Peter Preuss)]

@indrajit.shah

If the filename is present in the excel file then delete the file from the folder

Perfect so loop over the calculated list and delete the files

[indrajit.shah (iamvicky)]

@ppr

new DirectoryInfo(YourFolderPath).GetFiles().Select(Function (x) x.Name.ToUpper).toArray

@ppr Is there any wrong with this code?

[ppr (Peter Preuss)]

x is FileInfo (check and explore a little bit the attached cheatsheet along within the immediate panel)

When it is about: get the filenames without the extension:

new DirectoryInfo(YourPath).Getfiles().Select(Function (x) Path.GetFileNameWithoutExtension(x.Name)).ToArray

[indrajit.shah (iamvicky)]

@ppr

Assign Activity:
arrFileFoundAndNotInExcel |String Array =
arrPresentFileNames.Except(arrExcelFileNames).toArray

@ppr - this is giving the result of file that is unique not the one that needs to be deleted.

[Anil_G (Anil Gorthi)]

@indrajit.shah

I guess you need to use

arrPresentFileNames.intersect(arrExcelFileNames).toArray

Cheers

[ppr (Peter Preuss)]

@indrajit.shah

If the file is present then delete it and only keep the files which name is not present in the excel list.

Agreed to @Anil_G

@Anil_G

arrPresentFileNames.intersect(arrExcelFileNames).toArray

finding the common files

[indrajit.shah (iamvicky)]

@ppr
@Anil_G
thank you, I have used the same …intersect was not in my mind…but finally got it