Hello fellow geniuses.
In my best efforts to save time I need to come up with a solution for the following scenario:
1. Email message is received, it has an attached PDF file that contains an order number in the following format 123-456789-0123456 and a single UPS, FedEx or UPS tracking number somewhere in the PDF.
2. I need to be able to automatically extract the order number and the tracking number. For example we will say that our data looks like this somewhere in the PDF:
9400 4461 0122 2046 4902 26
The tracking number may or may not contain spaces for USPS and FedEx formats. So I need to find a tracking number inside the PDF that is a UPS, FedEx or USPS tracking number.
3. I need to save the extracted information into a mySQL database for later use.
My thoughts were to have some sort of application that can receive the emails at a dedicated email address so the data can be extracted and saved.
What is the shortest path to a solution this? What can the solution be?