SHORT EXPLANATION:
I need a program that automatically extracts couple of codes from a PDF and searches these couple of codes in some XLS files.
- where it finds full matches it writes the PDF filename on the matched XLS line
- where it finds full matches with differences just in the codes' spacing/punctuation/symbols, it logs the codes on a TXT file and append the actual PDF page on another PDF
- otherwise, it does nothing and continues with the next page/line...
____
LONG EXPLANATION WITH DETAILS:
I would like a little program or script, in Visual Basic .Net (I have .NET Framework 2.0 and Adobe Acrobat 7.0 trial v. installed) or other language of your choice, that works in this way:
The user selects:
A) a PDF file (see example of actual PDF here: [login to view URL])
B) a folder that contains many XLS with lists of codes (see example of actual XLSs here: [login to view URL])
Then the user press the "GO" button and the program automatically reads in the file A) all the codes that immediately follows the text string "OGGETTO: PROCESSO VERBALE N° " and the codes that immediately follows the text string "IN RIF. AL VEICOLO TARGATO : ", that are a couple per page, and tries to cross pair them with all the lines in the XLS files contained in the folder B). *
From now on, I'll call the first of these two above codes "VERBALE" and the second "TARGA".
* The criterium for the cross pairing is this: for each of these XLS files of the folder B) the program, more precisely, searches the TARGA and the VERBALE couples of codes of the PDF file A), through the columns A and B of all the XLS files of the folder B). Where it finds perfect coincidence of both codes of the couple of the PDF file A) with both codes in a line of one of the XLS files, it writes (as mark..) the name of the current PDF file A) in the relative (in the same line of the match) cell of the column F (the first empty column on the right, in the same line) of the current XLS file.
The special/dubious cases are to be managed in this way:
- in case of coincident TARGA and not coincident VERBALE, it doesn't consider it as a coincidence
- in case of not coincident TARGA and coincident VERBALE and in case of VERBALE and TARGA only different in the spacing or in the punctuation or symbols (ex. "-" instead of "/"), it logs the coordinates of the occurrence (ie. the name of the PDF and the name and line number of the XLS file where it found this dubious occurrence) on a file "[login to view URL]", and copies/append the PDF page of this dubious occurrence in a PDF file "[login to view URL]".
The program final message must be:
"Incrociamento completato con successo.
[login to view URL] contiene gli estremi delle occorrenze dubbie da controllare manualmente.
[login to view URL] contiene solo le pagine del PDF degli stessi casi dubbi, da stampare per agevolare il controllo manuale.
[OK button]"
____
I'll pay in advance by escrow and release it as soon as you finish, giving to me the full source code and working compiled code (ex. the EXE file).
Thank you very much for your bids.