At 2:47 PM -0500 10/31/01, <[EMAIL PROTECTED]> wrote: >Hi > >I didn't see any difference between using optionally or not. > >Any solutions to make the two that fails work? (see test case below) > >Using 3.23.41. > >Thanks
The problem is that your CSV file isn't legal CSV. You'll need to tell your application to generate correct CSV format. > > >test.csv: >"Record 1","some data","Works" >"Record 2",""some" data","Works" This line is illegal. >"Record 3","some 'data'","Works" >"Record 4",""some" "data","Works" So is this one. >"Record 5",""some"data"","Fails" And this one. >"Record 6","some"data","Works" And this one. >"Record 7","some data"","Fails" And this one. >"Record 8","'som"e"'data","Works" And this one. >"Record 9","some"data","Works" And this one. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php