Results 1 to 2 of 2
Jan 7, 2006, 20:41 #1
- Join Date
- Jan 2004
- 0 Post(s)
- 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?
Jan 7, 2006, 21:31 #2
- Join Date
- Jul 2005
- West Springfield, Massachusetts
- 112 Post(s)
- 1 Thread(s)
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"10 Rules for Driving Traffic Using Forums | Ultimate SEO Checklist
External links are nofollow
How to be a Great Online Community Member
Member of the Month for December 2013
Free SitePoint book - Thinking Web: Voices Of The Community
The 2013 SitePoint Awards - Nominations closed - Voting to begin soon
Introducing the new Code Review Forum