Data Remapping Program

I need a small program (preferably not web based) to remap text data. I need input File 1 to have its fields redesigned and an additional field to be added to each record from File 2.? The output FILE 3, MUST have EXACTLY the same ? format for each field and record as in the attached example. Just review attached spreadsheet for a more clear explanation. Output data must be in CSV ot Tab delimited format. INPUT 1 and 2 Files will be in .CSV format Please note: If record "ANI" (column C) ? Input File 1, does not have a match in FILE 2, the program must look at column PIN in file 1 and match it with the same number in column ANI of File 2, in order to find its control # and to assign it for Outputfile 3.? ? ## Deliverables Feel free to ask any questions