Jason Ferguson wrote:
The data is split into about 60 files, average file size of 5 MB (varying
from 1 to 10 MB). Since there are many files, I'm trying to minimize the
required work (if there was just one consolidated file, no problem).
The work can be automated easily with the right tools ;-)
If you have for example perl installed on your system and the files all
have the '.dat' extension, you can use:
perl -pi -e 's/unknown/0/gi' *.dat
All instances of 'unknown' (without the quotes of course and case
insensitive) will be replaced with '0' in all of the .dat files; use
different wildcard constructions if your file have other names.
Regards, Jigal.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
