From: Gary Mc Closkey (Gary.McCloskey at domain rte.ie)
Date: Thu 04 May 2000 - 12:27:47 IST
export the tables to ascii files, strip the characters using (awk|perl|emacs|tr), reimport to mysql ? Some sanity checking before he re-import might be helpful as well.
From: ilug-admin at domain linux.ie [mailto:ilug-admin at domain linux.ie]On Behalf Of John
Sent: Thursday, May 04, 2000 12:17 PM
To: Peter McEvoy
Cc: ilug at domain linux.ie
Subject: Re: [ILUG] wee coding challenge..
On Thu, May 04, 2000 at 12:14:12PM +0100, Peter McEvoy mentioned:
> Not sure how much SQL MySQL supports but you could try:
> update mytable
> set fullname = replace(fullname, ':');
> (this will replace every ':' with nothing, with extended args to replace,
> you can replace : with somthing else. Note that translate function won't
> work this way)
> Then repeat for all dodgy characters (unfortunately, regexp support is not
> that great in SQL so you can't do
> replace(fullname, /[^A-Za-z0-9]*/)
> but for a quick fix, this might help..
Alas, there are 70 odd chars that are allowed in email addresses, and 220
-- "The fool must be beaten with a stick, for an intelligent person the merest hint is sufficient" -- Zen Master Greg -- Irish Linux Users' Group: ilug at domain linux.ie http://www.linux.ie/mailman/listinfo/ilug for (un)subscription information. List maintainer: listmaster at domain linux.ie
This archive was generated by hypermail 2.1.6 : Thu 06 Feb 2003 - 13:06:01 GMT