Start a new topic

Export data with carriage returns

anonymous

started a topic about 16 years ago

[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

Roger Bjärevall

said almost 16 years ago

[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

How can we help you today?

Export data with carriage returns

anonymous

Roger Bjärevall