SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle SQL trim() vs MS Excel clean()

975098Nov 19 2012 — edited Nov 19 2012

I have some data being extracted from Oracle 11 db views into CSV files.
When importing the data into some other system, said other system's data importer crashes.
I can open the CSV files in MS Excel, apply its clean() function to some columns, paste the values of that, and then the CSV file is a bit smaller, unprintable characters are removed, and data importer in new system is OK.
Its a cumbersome process.
I tried Oracle SQL trim() but it doesn't remove all the chars, it seems, that MS Excel clean() function removes.
Is there a comparable Oracle SQL function that does what [MS Excel clean()|http://office.microsoft.com/en-us/excel-help/clean-HP005209014.aspx] does?

Edited by: 972095 on Nov 19, 2012 2:35 PM

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 17 2012

Added on Nov 19 2012

1 comment

1,095 views