Splitting LASTNAME,FIRSTNAME columns in Excel
Wednesday, May 14th, 2008 Posted in tech tips | 1 Comment »Too often, office workers have to manipulate improperly structured data that comes from mega-systems. For example, if a person wanted to do a mail merge intro line, stating, "Dear <firstname>" but the name field held LASTNAME,FIRSTNAME, they would have a ...
Export data from MySQL to CSV using PHP
Thursday, March 20th, 2008 Posted in webdev | No Comments »In a recent project, we were collecting registrations for an event using a PHP web form and a MySQL database. The office worker wanted to download all of the collected data in an excel file. In a subsequent meeting with ...