SitePoint Sponsor |
|
User Tag List
Results 1 to 2 of 2
-
Jan 7, 2006, 21:41 #1
- Join Date
- Jan 2004
- Location
- Nashville
- Posts
- 335
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Error IMporting data from .csv to mysql
I am getting an error indicating that possibly an incorrect field delimiter is inb my .csv file. I searched the file with Excel looking for extra, "," & ";" but I still get an error indicating that there is some kind of unexpected field delimeter in the file.
Is there a way to "clean" a .csv file to make sure it is ready to be imported into a sql table?
Thank you
-
Jan 7, 2006, 22:31 #2
- Join Date
- Jul 2005
- Location
- West Springfield, Massachusetts
- Posts
- 17,290
- Mentioned
- 198 Post(s)
- Tagged
- 3 Thread(s)
delimiter
I wouldn't look for an "extra" delimiter, but for an "incorrect" delimiter. It might be something as subtle as a space. eg. "field1","field2" ,"field3","field4"
Maybe even a space before the newline that you can't see without "select" highlighting. Or maybe extra quotes eg. "field1","field"2"","field3"Big Change Coming Soon - if you want your PMs save them now!
What you need to do to prepare for our migration to Discourse
A New SitePoint Forum Experience: Our Move to Discourse
Bookmarks