Deleting files which have the same duplicate name in path except one

[david.mitrovic]

Hi

I am looking for a solution where I would like to delete all files with the same number in the name except one file should remain. In short: Doubles files should be deleted and one should be kept.

[THIRU_NANI (NaNi)]

Hey!

We have similar thread… have a view on this

Delete duplicate files in folders

Good day to all I have a process that generates some files that are saved in folder 1 I have to validate if the files generated are any that exist in folder 2, if this is true I have to delete them and only pass the files that are not repeated in any of the two folders to generate folder 3 I appreciate if anyone can help me with this issue.

Regards,
NaNi

[Nithinkrishna]

Hey @david.mitrovic

Get all the files from the folder with the filter condition of containing the number you have mentioned.

Directory.GetFiles()

Then you can loop through each file expect first and then delete those using Delete File activity.

Hope that helps.

Thanks
#nK

[david.mitrovic]

how can I skip the first entry in the if activity?

[THIRU_NANI (NaNi)]

Hey!

If condition = True this will go to the then block…

In else block do then False process…

Regards,
NaNi

[Nithinkrishna]

In the for-each once you get the files array just do the below,

arrFiles.Skip(1)

[Gangadhar_Athili]

Directory.GetFiles(“C:\Users\Gangstar\OneDrive\Desktop\Test”).GroupBy(Function(F) F.split("_“c)(3).Split(” "c)(0)).Select(Function(g) g.First).Toarray