Importing Excel CSV files into PhpMyAdmin

So sadly, Excel doesn’t enclose its CSV fields with double-quotes (“) which phpMyadmin needs. This workaround I found on the Microsoft support site: Open the original CSV file in Excel Run the macro listed above (repeated here) to save out the file: Sub QuoteCommaExport() ‘ Dimension all variables. Dim DestFile As String Dim FileNum As… Continue reading Importing Excel CSV files into PhpMyAdmin

Recursively deleting files matching wildcards

I find this useful for “un-versioning” a Subversioned directory structure. Works via Cygwin, not sure if there’s a pure Windows equivalent: $ rm -rvf `find . -name ‘.svn*’` Credit goes to one of the replies on this forum.