> It seems that one of the tables we need to export and import >contains rows which is used for dropdown menus. > > > > This has the following effect: > > > >. Each item in the "text" field is added in the field by entering >the country name then pressing enter and then entering the next, etc.... > >. When exporting the data to a file (even when enclosing each field >within quotes) it still writes the control characters causing each item to >be read as a different line and thus the import into Oracle fails. > > [JS] Leaving aside my opinion that this is a bad way to store options for a dropdown menu, I think you will need to use the REPLACE() function liberally.
In fact, you might consider using CONCAT_WS() to cram all of your fields into one and then using REPLACE() on the result. I don't know how that will work with your data, but I've done it before when otherwise stumped. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
