If it's an option, I would run your datafile through a processor (sed on unix, ultraedit on windows) to search and replace the string "" with \"
and try it with fields terminated by ',' optionally enclosed by '"' as mentioned by Mike Johnson's posting (escaped by '\' is default) > -----Original Message----- > From: Daniel Kiss [mailto:[EMAIL PROTECTED] > Sent: Tuesday, December 09, 2003 3:02 PM > To: [EMAIL PROTECTED] > Subject: LOAD DATA LOCAL INFILE > > > Hi all, > > How should I set the parameters of the LOAD DATA LOCAL INFILE > command for a comma separated text file like this: > > "Text field",.4,123 > "Text field with "" included quote",,45 > "Text field with "","" a comma between quotes",1.2,44 > > Thanks, > Dan > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
