Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Apr 2016
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Search .pdf, .doc, .ppt files for information contained in excel cells and return path

    Hi,

    I have an Excel spreadsheet with a "drug name" in column A. The "drug name" listed in column A appear in one or more Ms office .doc .pdf .ppt files in one or more source directories.

    I need Excel to search the files recursively and return the path(s) of the file(s) that contain the "drug name" specified in column A into column B. If more than one file go to column C etc.

    Is that possible? Is it possible to search in a sounds like manner? Is it also possible to search in greek (is it intonation sensitive?)?
    Thank you in advance

  2. #2
    WS Lounge VIP
    Join Date
    Dec 2009
    Location
    Earth
    Posts
    8,197
    Thanks
    48
    Thanked 986 Times in 916 Posts
    You can use Excel to read the file names for a specific word, but I doubt you will be able to search file content, particularly as you have multiple formats.
    If Windows search has indexed the files and allows you to find specific words you may be able to leverage Windows to automate the search, but it's not a simple task.

    PowerShell to query Windows Search links
    http://stackoverflow.com/questions/1...ith-powershell
    https://www.petri.com/how-to-query-t...and-powershell
    https://blogs.technet.microsoft.com/...om-powershell/

    cheers, Paul

  3. #3
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,832
    Thanks
    136
    Thanked 484 Times in 461 Posts
    Hi

    Paul is right.
    It is not a simple task.

    Here are some issues you may need to consider:
    1. How many files have to be searched? (1TB drive could contain 1 million 1MB files, 2 million 500Kb files etc )
    2. What if files are password protected?
    3. What about encrypted folders?
    4. What about files contained in, say, compressed zip files?
    5. What about new files being added to folders after you have already 'processed' that folder

    There are many other things to consider too.
    However, if you've gotta do it, then, well, it is possible.
    And it could be done.
    Searching files for drugs??? Sounds like a job for the DEA!

    zeddy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •