MySQL Forums
Forum List  »  Other Migration

export table with rich-text
Posted by: Pietro Moro
Date: January 20, 2011 03:59AM

I need to export a table to massively modify the content, either via a script or in MSExcel.
The items of this table contain rich text, with CR character and " character.
Which is a proper way to export (and later import, after modifications) the table?
I have tried to export as CSV text file, with parameters:
- separation char ;
- grouping char # (not ")
But CR char forces a new line to be output, so that I cannot distinguish a CR of the text from a new item.

Options: ReplyQuote


Subject
Views
Written By
Posted
export table with rich-text
4680
January 20, 2011 03:59AM
1999
January 20, 2011 07:05AM


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.