Find a list of files within a folder structure

Hello

I have a complex folder structure with lots (000s) of files, and a list as a .txt file of 80 filenames I need to find the matching files for.

Is there a simple way to turn the list into a search criteria?

Thank you

The most straightforward way I can think of is to build up a filter with all the names.

You could have a separate line/clause in the filter for each name, but that would involve a lot of clicking. To reduce that, you can combine several names into a single line as shown below.

Depending on the total length of the names, you might need to use more than one line (but if the names are short enough, they could all fit in a single line).


Thanks Leo. With 80 files with quite long names to find I can't see that being much of a timesaver unfortunately.

Are saved filters stored in a file that's editable? If so maybe I could find and replace in a text editor to build the filter automatically?

They're stored in XML files under /dopusdata/Filters so you could edit them in a texteditor. If you've got an editor which does macros (or something like a "mail merge" feature maybe) it should be fairly straight forward.

If it's a one-off, feel free to post the list of files here or via a private message and I can make the filter for you.

Fantastic! Worked perfectly

It's not a one off, but even so I wouldn't expect you to do my donkey work for me :slight_smile:

Here's an anonymised version of what I used if anyone else has the same requirement:

[code]<?xml version="1.0" encoding="UTF-8"?>

filename0.pdf
filename2.pdf
filename3.pdf
filename4.pdf
filename5.pdf
filename6.pdf
filename7.pdf
filename8.pdf
filename9.pdf
filename10.pdf
filename11.pdf
filename12.pdf
filename13.pdf
filename14.pdf
filename15.pdf
filename16.pdf
filename17.pdf
filename18.pdf
filename19.pdf
filename20.pdf
filename21.pdf
filename22.pdf

[/code]

Note that the clause for the first filename is slightly different from the rest as it's the 'stem' and all the others are the 'or'.

Various ways you can build the 'or' clauses. I used Excel - put the bit to the left of the filename in one column and copy down, filenames listed in the next column, bit to the right in the third column, and do a CONCATENATE() to build the expression, then simply copy and paste into the .ofi file.

Might sound a bit complex, but it took less time than it's taken for me to type this post :slight_smile:

Thanks for guiding me in the right direction leo, much appreciated