|
|
|
Junior Member
 
Group: Forum Members
Last Login: 9/23/2009 2:43:54 PM
Posts: 24,
Visits: 36
|
|
I am performing some stress tests of user queries, and the query text contains carriage returns. When I try to put this data in an Excel spreadsheet, it breaks up the query text. I tried checking the appropriate box on the EXPORT tab on SQL Assistant, but the carriage return remains in my result set.
Any suggesstions?
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: Today @ 2:07:30 AM
Posts: 112,
Visits: 264
|
|
I tried it with Queryman 12 and it got rid of the carriage returns fine - whether or not the option was set!?!
If you have the Oracle UDF's installed, use the following to get rid of carriage return from a field ChrFld:
Select
OReplace(CharFld,'0D'XC)
It will get rid of carriage return anywhere from the field.
|
|
|
|