You have chosen to sponsor your bid up to a maximum amount of .
I need .xlsm Excel file that can import and process one or more TSV files (TAB separated values) and compare the values with previously imported data and dump the results in CSV files.
All of these points must be met:
- There must be a "settings" sheet that will contain different variables.
- The files must be imported automatically, file names/paths will be listed in the Settings sheet
- The TSV can contain one or multiple columns
- The values need to be compared (exact match - although not Case Sensitive)
- The results will be exported into 2 text files: "Identical" and "Different" in a new folder (Folder name = Date Time - eg.: D:\28.03.2011 1730)
- In the "Identical.txt" file, I want to have the names of the files that were identical after comparison
- In the "Different.csv" file I want to have the following values: "filename,original_text,new_text"