38465 PDF to XLS cross pairing prog.

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: [url removed, login to view]) B) a folder that contains many XLS with lists of codes (see example of actual XLSs here: [url removed, login to view]) 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 "[url removed, login to view]", and copies/append the PDF page of this dubious occurrence in a PDF file "[url removed, login to view]". The program final message must be: "Incrociamento completato con successo. [url removed, login to view] contiene gli estremi delle occorrenze dubbie da controllare manualmente. [url removed, login to view] 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.

Kemahiran: .NET, Semua Boleh, Pengaturcaraan C, Perl, PHP, Visual Basic

Lihat lagi: www escrow con, where two lines cross, tries com, string match, php codes pdf, pair of lines, pair line, match string, le code, finish line com, cross with two lines, coincident lines, case escrow, 4 tries, perl framework, compiled language, acrobat adobe, call escrow com, xls, pdf script

Tentang Majikan:
( 3 ulasan ) Roma, Italy

ID Projek: #1788048

Dianugerahkan kepada:


I'm ready.

$50 USD dalam 0 hari
(4 Ulasan)