All Forums Analytics
JustMe 76 posts Joined 03/07
16 Sep 2009
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?

Jimm 298 posts Joined 09/07
16 Sep 2009

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:SelectOReplace(CharFld,'0D'XC)It will get rid of carriage return anywhere from the field.

You must sign in to leave a comment.