Make changes to the data file comparison project already completed.
$30-250 USD
Completed
Posted about 10 years ago
$30-250 USD
Paid on delivery
This is an update to already completed project. This will be a private bid available only to the freelancer (alquarizm) who completed the original project.
1. Change the input and output format into CSV file.
Instead of reading/writing to excel i would like the new version to read from and write into a csv file.
(The format would be exactly the same as in excel file I've sent previously).
User should have the following interface controls:
a) Select Vantage file: (this is the file with 9 character entries where last character on the right has to be removed)
b) Select Sigma file: (this is the file with 8 character entries)
c) Choose destination file: (user should be able to choose the destination and name for the output CSV file).
2. Add stats:
I would like to provide the following summary at the end of the output file:
a) Total number of entries processed: #;
b) Number of exact matches: #;
c) Number of instances where there are entries in Sigma (second file) but no entries in Vantage (first file): #;
d) Number of instances where there are entries in Vantage but no entries in Sigma: #;
Please create this as a separate project from the first one.
Please send me two separate archives with both complete projects, i will install netbeans and go over the code - I am very interested in how it is done programmatically.
Thank you very much,
Yan.