Remove duplicates from CSV files in a flash with an AutoHotKey script

Remove-DuplicatesIn email marketing I am frequently having to remove duplicates.   I typically used Excel for this but I did it so frequently I built a small script to automate the process.

The program requires a CSV file and utilizes Microsoft’s Component Object Model to open Excel and examine the headers for a field named “email”.  Once it finds it it removes duplicate email addresses and saves them as a new file in the same folder with the naming showing how many rows are present.   This greatly reduces the amount of work needed to do the job.
This should ease the removal of duplicates from CSV files.

Remove duplicates demo video

Removing Duplicates from CSV files

SPSS script to Create readily accepted CSV files to online tools

SPSS ScriptsWhile SPSS has a built in capability of exporting to CSV, it doesn’t export in a format that most online tools accept.  I wrote an SPSS script which accepts one parameter (the path & name of the file) then it exports the file into a better CSV format that tools do accept.

Demonstrates the use of a parsing script to create CSV files that are ready to be uploaded to survey tools

Video Demonstrating SPSS Script to Export to CSV

Creating CSV files from SPSS