Hmm...that seems like a bug...if those commas are inside quotes, they should not be interpreted as field delimiters. You might want to check if there are any stray quotes elsewhere on the line that are messing up the interpretation. If not, then I would think that to be a bug.
j----- k----- On Thursday 08 July 2004 09:23 am, John Mistler said something like: > I appreciated your first email, regardless of whether or not I was able to > make it work. Any response is welcome! I am having some trouble with the > final result using the CVS file: some of the content uses commas i.e. > "Chinchilla Zúñiga, Guillermo" and gets split up between two fields. This > whole process is pretty messy, but I'm sure I will find a solution. The > tools I was directed to below at freshmeat.net are a little out of my > league. I am a Macintosh user that programs in applescript, a little > obj-C, and SQL. I don't know if I can even implement those classes. <SNIP> > >>> LOAD DATA INFILE 'myfile.cdf' INTO TABLE mytable > >>> FIELDS TERMINATED BY ',' ENCLOSED BY '"' > >>> LINES TERMINATED BY '\n'; -- Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295 Every knee shall bow, and every tongue confess, in heaven, on earth, and under the earth, that Jesus Christ is LORD -- Count on it! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
