I have thousands of unique strings that I need to capture from unstructured files.
These files are stored on 9 x UNC shares. The unique string that I need to capture is actually stored in the file names on these share so this should be possible if you have the knowhow.
The file names stored on these shares have only two naming formats::
e.g. \share1\customer\saleID\ Note that there can be another sub directory again underneath saleID. Each customer has their own directory, each saleID folder is unique.
I need to capture only every unique PARTNUMBER from these file names on the 9 shares.
There may be one or more files with the same part number but I only need to record it once i.e. remove duplicates - and save these out to a *.CSV file.
Help appreciated as I have no clue where to start!