-
Split multiline pipe-delimited string into columns and rows in MySQL
Do you have an output that is in comma or pipe-delimited format and you want to go digging in a MySQL database for the data that corresponds to that output? Don’t feel like cutting and pasting and/or scripting in a language better suited for the task and just want it all to happen in MySQL…
-
perl script to generate a list of Julian day/day of year dates, given start and end.
I discovered myself on a unix system with a ‘date’ utility that only accepts the -u and + parameters, a fairly basic perl install, and lots of archives that are listed by the “Julian day” (day of year) date. I put together a perl script using the functions I had at my disposal. The script…