SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Addict
    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

  2. #2
    Programming Team silver trophybronze trophy
    Mittineague's Avatar
    Join Date
    Jul 2005
    Location
    West Springfield, Massachusetts
    Posts
    17,014
    Mentioned
    187 Post(s)
    Tagged
    2 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"


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •