Find Lines in CSV file then move them in another file

[bettlejus]

Hi all,

I need a vbs to search a specific CSV file for lines containing words from another input txt file and then move the lines where the text was found to another CSV file of same format.

Little example:

CSV Original:

NAME , COUNTRY , DATE
name1, country1, date1
name2, country2, date2
name3, country2, date2

TXT file with search word will contain the following: "name1, name2"

I need the script to search the input CSV for those lines containing the entries from TXT and copy those line in another CSV file with same format, ex:

CSV Final:
NAME , COUNTRY , DATE
name1, country1, date1
name2, country2, date2

Any help is greatly appreciated.

Thank you!

 

[bettlejus]

Or an option instead of the input file for search string, those can be in excel sheet in column A and then search one by one in a CSV/TXT file and put them in another CSV/TXT file.