While working on the email handling I’ve been creating a fair amount of data. I started doing this using Excel by simply using the CONCATENATE function to build up INSERT statements.
That seems a little odd but works quite well…however I have found a better way. NimbleText is a utility that uses CSV and Regular Expressions to expand a text sequence to a set of results. It’s pretty cool and you can write multi-line SQL INSERT queries from an array of data very quickly.
Check it out its super useful!