Requirement with folder names and file names

Hi Gurus,

Here with this message I am attaching one zip folder which have my requirement. I have to process the data as per the folder name along with file name. Kindly go through the attachment and guide me accordingly.

Regards
Sateesh.K

Hi,
I have different client id folders which contains different pdf files which have important identification names in the file name.
Example: Folder name is "Testing" and this folder contains 3 pdf files with different identification names in the file name.
In the "processed" excel I am expecting to take
A column's format is: Folder name/Filename.ext Example: TESTING\00001_FAST_FURIOUS.PDF
B Column should take Furious word as a First name
C Column should take Fast as a Last Name.
This format is fixed format. Plz guide me.

Sateesh.K

Hi,
I have different client id folders which contains different pdf files which have important identification names in the file name.
Example: Folder name is "Testing" and this folder contains 3 pdf files with different identification names in the file name.
In the "processed" excel I am expecting to take
A column's format is: Folder name/Filename.ext Example: TESTING/00001_FAST_FURIOUS.PDF
B Column should take Furious word as a First name
C Column should take Fast as a Last Name.
This format is fixed format. Plz guide me.

Sateesh.K