Question Search for a filenames in a folder

[vijay2482]

Hi all,

I have an application that has a list of string that needs to be search in a database table field to select rows with the same name and retrive the values of one particular fields that contains the file name with extention for that string.

With this new generated text file, I pass the filename with the extension and search the folders that are listed in a txt file.

All of this works fine.

Now I need a more simple version of this application, without using the database to get the filename with extension.

Instead, read the text file with input strings, search in the folders listed in another text file(to know the location of the folders to search for the string).
If any file that matches with the string in the text file, I need to copy those files to another folder.

eg:
Input file:

DRAWINGS LIST
-------------
400422M91
3052943M4
1426075M1

List of folders to search txt file:

U:\plans_tif
U:\plans_tif\CFS
U:\plans_tif\CS
U:\plans_tif\CORPORATE_STD_GLOBAL_AGCO
U:\plans_tif\Doc_Eng
U:\plans_tif\Doc_Technique
U:\plans_tif\Export_Gima
U:\plans_tif\Part_1
U:\plans_tif\Part_2
U:\plans_tif\Part_3
U:\plans_tif\Part_4
U:\plans_tif\Part_5
U:\plans_tif\Part_6
U:\plans_tif\Part_7
U:\plans_tif\Part_8
U:\plans_tif\Part_9
U:\plans_tif\Part_10
U:\plans_tif\Part_11
U:\plans_tif\Part_12
U:\plans_tif\Proe_Components
U:\plans_tif\Specifications

example files in the folders:

400422M91.01.0101.TIF
3052943M4.07.0101.PDF
1426075M1.01.0103.TIF
1426075M1.01.0203.TIF
1426075M1.01.0303.TIF

All these files should be copied to another folder.
Please find the attached input file, folder to search file, and also the application with the connection to batabase.
I know it will not be possible to execute, as the database will be missing, but just to be sure, that I have a working application.

Any help will be helpful.
Thanks in advance.