On Thu, 08 Jul 2004 21:12:01 -0400, "leegold" <[EMAIL PROTECTED]> said: > I have a situation were a table field item has a > situation like: \r\ndata\r\n. So an item's got > line breaks in there with it in the field and > it's screwing things up for me. How do I do a global > clean-up of this and remove all \r and \n for > all of that col. in my table? If it was flat-file > I'd run a Perl regex,
I just did a mysqldump to a file and looked at it with a text editor and I see the '\r\n' surrounding my items. Maybe this could be a file I can unleash a regex on. It's a very simple regex. Then I load the load file into the "new" DB as planned - I wonder if I would break anything? Actually now I'm thinking there are "backdoors"/tricks to editing this type of thing (w/appropiate backups). >but how w/data in MYSQL tables? > Thanks for helping with this novice/easy stuff - OK > if you can just link me to the info. Lee G. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
