I often get text files of similar type (Tab delimited, CSV, etc.) but they all have a header row. A super easy way to merge the data together is to
- Created a folder that only has the files you want to merge
- create a command prompt in the directory
- use the following dos command to merge the files (adjusting the extension to your purpose: copy *.csv merged.csv
This will merge all of the files ending in .csv into the merged.csv file however it keeps all the header rows. :( This annoyed me so I wrote a short program to use AutoHotkey and only keep the first header row.
Continue reading

My friend had over 3,000 contacts in his Android phone and we wanted to automate texting & emailing them. Android exports to VCF files but it is a crappy format! Maestrith and I wrote this script which “flattens” the file into a tab delimited format.
I use ClassName a lot when