Print Page - how to get rid of special character

Title: how to get rid of special character
Post by: barrysaab on 12 Sep 2013 02:26:16 AM

I have a list report and my native database is teradata,the problem i am encountering i am getting a output like PDAS?ASGRACI?M when i run a report for product name.Please note that i have varying length product name ,I have tried

substring(character_length(description)) and SUBSTR(LENGTH(COLUMN)-4) Both giving me error.Please help.Thanks

Title: Re: how to get rid of special character
Post by: adik on 12 Sep 2013 07:42:09 AM

substring(column from x to y) or substring (column, x, y) - this is the terradata substring function

Title: Re: how to get rid of special character
Post by: barrysaab on 13 Sep 2013 01:41:29 AM

Thanks adik but my character length is not fixed.

Title: Re: how to get rid of special character
Post by: adik on 13 Sep 2013 01:52:29 AM

i'm not sure how it is in teradata world, but in oracle i would try something like this
substr(column, instr(column, character, start position, nth apparence) + 1, instr(column, character, start position, nth apparence + 1)))

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: barrysaab on 12 Sep 2013 02:26:16 AM