Jump to content

phpmyadmin, importing csv, getting quotes around some fields


glennn.php

Recommended Posts

i have fields such as this in a csv file:

 

6" X 4" Document Placard

 

but when they're imported into my db, they end up as

 

"6"" X 4"" Document Placard"

 

i can't discover why this is happening not how to prevent it.

 

anyone?

 

i HAVE adjusted the "fields terminated by" and "fields enclosed by" fields in the import, with no change...

 

help?

 

thanks much

Link to comment
Share on other sites

ok, i appreciate it - but what i don't get is that the data is WITHOUT the quotes IN Excel - it happens during the import INTO the database - so how is it that Excel is causing it? even after the .csv import, the data in the .csv file is fine (WITHOUT the quotes).

 

only the data in mysql is affected...

 

when you say "clean it up with regexp", you mean to clean the mysql data with regexp???

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.