David Blomstrom wrote:
I just saved a spreadsheet (Microsoft Works) as a csv
file and imported it into a database. It worked fine,
except for some links, which acquired double quotes
when I saved the file as a csv file. In other words,
they now look like this:
<a href=""www.geobop.org/"">Geobop</a>
Do you have any idea what might cause this? Is there a
way purge these double quotes in MySQL? I can do a
search and replace in my csv file, but it takes a long
time, as it's a huge file.
If you plan on using this process again, you may want to track down the
source of the problem, but if you aren't going to be exporting this way
again and you just want to fix it, I would just open the csv file in a
text editor and do a search and replace.
--
Chris W
Bring Back the HP 15C
http://hp15c.org
Not getting the gifts you want? The Wish Zone can help.
http://thewishzone.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
