quotes are appearing when using udfconcat function

Database
Visitor

quotes are appearing when using udfconcat function

Hi,

 

For one of my requirement , i got to know that tdstats.udfconcat() function can be used to concatenate rows instead of writing recursive query from Teradata forums.

I used this function but i am getting results with quotes.

for example: 

"AB","AA"
"AC","AD","AF"
"AG"

 

But i want my output with out quotes like

AB,AA

AC,AD,AF

AG

 

I am using Teradata Express Studio.  Please help me.

 

Regards,

Badri

1 REPLY
Enthusiast

Re: quotes are appearing when using udfconcat function

Isn't there a string replacement function whereby you could easily remove the double quotes ?