krishbhargav
12-09-2016, 03:01 PM
Hi,
I have been working on a code to loop through every string in every pdf file in a folder and look for Postcodes that could be listed in the file and taking into consideration that the postcodes could be in any of the below format. Once we find all of the strings in the below format then the strings needs to be copied into a excel document. I have hit a brickwall with this and I m yet to find a solution for this. I have looked for help on the internet and not much help out there. Could some one kindly help me with the code please? Really appreciate your patience.
Format Example
AN NAA M1 1AA
ANN NAA M60 1NW
AAN NAA CR2 6XH
AANN NAA DN55 1PT
ANA NAA W1A 1HQ
AANA NAA EC1A 1BB
Regards,
Krish
I have been working on a code to loop through every string in every pdf file in a folder and look for Postcodes that could be listed in the file and taking into consideration that the postcodes could be in any of the below format. Once we find all of the strings in the below format then the strings needs to be copied into a excel document. I have hit a brickwall with this and I m yet to find a solution for this. I have looked for help on the internet and not much help out there. Could some one kindly help me with the code please? Really appreciate your patience.
Format Example
AN NAA M1 1AA
ANN NAA M60 1NW
AAN NAA CR2 6XH
AANN NAA DN55 1PT
ANA NAA W1A 1HQ
AANA NAA EC1A 1BB
Regards,
Krish