if you use access, and link the txt files, should take you about 5 minutes to
write the queries..

"flaterp" wrote:

I have about 80 text files (.txt) that contain results of PC vulnerability
scans. Each file represents a different machine, and each file contains
multiple "Passed" and/or "Failed" results depending on what vulnerabilities
are present. All files are in a common networked folder - separate from the
Excel spreadsheet.
I wish to query each file for any instances of "=Failed" and output the
preceeding 12 alphanumeric characters into a cell. "=Passed" can be ignored.

For instance, if "testcase1.txt" contains the following data:
2005_292_004=Failed
2005_292_005=Failed
2005_315_001=Passed

Then the reference cell should return "2005_292_004, 2005_292_005"; if all
were "Passed" then the cell can read "none".

So if multiple files were queried, the xls may look like below (the '|'
indicates separate columns:
testcase1.txt | 2005_292_004, 2005_292_005
testcase2.txt | None
testcase3.txt | 2005_292_004
testcase4.txt | 2005_315_005
testcase5.txt | None


Thank you for any help.

I am not familiar with Access and other data is within the existing
spreadsheet, so I would like to use it.


"TomHinkle" wrote:

if you use access, and link the txt files, should take you about 5 minutes to
write the queries..