Teradata SQL Assistant result set

Analytics
Enthusiast

Teradata SQL Assistant result set

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?
1 REPLY
Enthusiast

Re: Teradata SQL Assistant result set

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.