I would prefer this to be a Delphi application, but I will accept any environment where I can have a free standing application that can be installed locally. I do not want a web application.
I need an application that can read two separate csv files. File "A" will be a customer file with multiple fields. The fields can very, but the customers phone number will always be the first field. File "B" will be a CSV file of phone numbers for clients we already work with. The program needs to remove all entries from the "A" file that are in the "B" file and then create a "C" file that represents all records from the "A" file that were not found in the "B" file.
Finally, I would like you to post a second quote in PMB for an "add" where your program can take into account non numberic characters. So that if the "A" file has the phone number as 888-123-4567 and the "B" file has the number 8881234567, the record would still be removed. Basically your program would remove all non-numeric characters and then do the compare.
If you have questions, please PMB. I hope to have this application soon.
Thanks in advance.