Re: Importing CSV files to MySql Db issue.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Chris Carter wrote:
I am not using spaces for closing. Every field is tightly packed with comma
only. No spaces, no semicolon. The reason I used space is if I use space at
least 3 or 4 fields get uploaded but not all. But we can ignore space for
now as it happened earlier.

Then your issue will be a comma in your data.

Header: Company Name, Name
#1: Widget Co, Chris
#2: Widget Co, New York, Chris

#1 will work fine.

#2 will be seen as
"company name" -> "Widget Co"
"Name" -> "New York"

Extra data -> "Chris" at the end.

Enclose your entries with something (" or ' or ~ or something else that's not going to be in your data).


--
Postgresql & php tutorials
http://www.designmagick.com/

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux