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?