[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.
over 11 years ago
[This reply is migrated from our old forums.]
Re: Export data with carriage returns
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.