At 2:47 PM -0500 10/31/01, <sql@stripped> 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.
