how do I search a word or pdf for a list of names in a CSV file?

**Martin Crane** · 01-30-2008, 04:43 PM

hello,
I am new to the forum and have a question that I hope hasn't been answered (I tried searching to no avail). Here is my problem.

I have 2 documents: one is an excel CSV list of names, the other is a searchable PDF list of names (which I can convert to word file or an HTML file). Both documents are several hundred names long. I want to be able to search the PDF to see if any of the names on the excel file occur. I want to be able to search the PDF individually for each name on the CSV. Because the files are hundreds of names long, I wanted to automate the process. Any ideas on how to do so?

**jevni1974** · 01-30-2008, 05:16 PM

Hi Martin,

You mentone that you could copy the data from PDF to Word.
If that is possible you can also copy that list to an excel file.

So if you can create an excel file that has :

sheet 1, containing the csv list you have
sheet 2, containing the data you copied from your PDF file

you can use the VLOOKUP or MATCH functions to check if the names on sheet 1 can be found on sheet 2.

Would that solve your problem?

how do I search a word or pdf for a list of names in a CSV file?

LinkBack

Thread Tools

Rate This Thread

Display

how do I search a word or pdf for a list of names in a CSV file?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions