Start a new topic

Export data with carriage returns

[This topic is migrated from our old forums. The original author name has been removed]

Hi All - When exporting data is there a way to convert the \r\n and \n hidden characters into valid insert statements? Our front end allows users to use carriage returns. We then use DbVisualizer to export the data as SQL insert statements, which are saved in a rtf file for loading into an Oracle database. Is there a way to replace the \r\n with chr(13) || chr(10) for clean insert scripts. Thanks for the help. Carter
1 Comment

[This reply is migrated from our old forums.]

Re: Export data with carriage returns
Carter, Currently it is not possible to transform characters the way you describe. I do however think it is a good idea and will add it to the future list. Thanks! Best Regards Roger