MySQL Forums
Forum List  »  CSV Storage Engine

Re: CSV LOAD DATA Question: line term in quoted field
Posted by: douglas_reith
Date: May 01, 2006 10:29PM

Thanks for this Bill.

I suppose I was hoping that the ambiguity was solved via the use of the closing quote mark.

Editing the file is unfortunately a difficult proposal due to the number of entries - i may have to write a little program that finds opening quotes and converts any '\n\r' to '\n' or some other carriage return (such as <br>) until it reaches the close quotation.

This could get interesting :)

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: CSV LOAD DATA Question: line term in quoted field
8027
May 01, 2006 10:29PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.