Find Jobs
Hire Freelancers

38465 PDF to XLS cross pairing prog.

N/A

Complété
Publié il y a plus de 18 ans

N/A

Payé lors de la livraison
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.
N° de projet : 1788048

Concernant le projet

1 proposition
Projet à distance
Actif à il y a 12 ans

Cherchez-vous à gagner de l'argent ?

Avantages de faire une offre sur Freelancer

Fixez votre budget et vos délais
Soyez payé pour votre travail
Surlignez votre proposition
Il est gratuit de s'inscrire et de faire des offres sur des travaux
Décerné à :
Avatar de l'utilisateur
I'm ready.
$50 USD en 0 jour
5,0 (4 commentaires)
6,8
6,8

À propos du client

Drapeau de ITALY
Roma, Italy
5,0
3
Membre depuis janv. 6, 2006

Vérification du client

Merci ! Nous vous avons envoyé un lien par e-mail afin de réclamer votre crédit gratuit.
Une erreur a eu lieu lors de l'envoi de votre e-mail. Veuillez réessayer.
Utilisateurs enregistrés Total des travaux publiés
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Chargement de l'aperçu
Permission donnée pour la géolocalisation.
Votre session de connexion a expiré et vous avez été déconnecté. Veuillez vous connecter à nouveau.