I have to regularly insert bulk data in tab-delimited format for realty-related site.
I tried using phpMyAdmin and MySQLinput to perform this task. Well, what can I say - cool scripts, but what I really need is to _format_ text before import.
I have to delete several columns, merge 2 columns in 1 and delete trailing spaces in each column.
What is the easiest way to perform that task? PHP or maybe Perl script? Perhaps there is something handy that I can download without writing code myself?
I tried using phpMyAdmin and MySQLinput to perform this task. Well, what can I say - cool scripts, but what I really need is to _format_ text before import.
I have to delete several columns, merge 2 columns in 1 and delete trailing spaces in each column.
What is the easiest way to perform that task? PHP or maybe Perl script? Perhaps there is something handy that I can download without writing code myself?