Filter a Collection based upon what a file name starts with?

[pseevs]

This sounds to me like it should be easy but I haven't figured it out yet.

I have a collection of excel files within BP and I want to filter them because for some reason once I get them inside BP, some of the files are duplicated; Fortunately, the duplicates all add a "~" to the start of their file name, so I should be able to easily separate them from the actual collection I want to work with- I'm just not sure how. I am in Utility Collection Manipulation and I have tried messing around with the StartsWith function, but so far no luck. Any advice?

 

[yeturirpa]

Hi Seevs,

In utility file management there is a action for to delete files based on the pattern of the files. in the pattern you can give your condition like "~*" it will delete all the files which starts with ~.

Hope you find the solution.