Merge CSV Files
I used Retrievem to merge the 37 CSV files

Task: Combine 37 comma separated values files (.CSV) into one


  • Cross-reference each component in the CSV files with a Master list of components
  • Remove duplicates after the merge
  • Generate two reports: a component list; a missing components list

Since the client just wanted two clean files, I was free to use my software to automate the merge. (Otherwise, I would have had to write a macro for him to be able to it on his computer.)

Click on a project link for more details about that specific project.