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