Print Page - Replace a number with multiple dots stored in the database without dots

Title: Replace a number with multiple dots stored in the database without dots
Post by: cognovice on 11 Feb 2025 05:28:43 PM

Hi All,
Is there a way where a number that is stored in the database with multiple dots to display the same without any dots in Cognos report studio?

example-> 084.443.222.9-006.000 to be displayed as 0844432229006000

Please assist.

Kind Regards,
R

Title: Re: Replace a number with multiple dots stored in the database without dots
Post by: dougp on 12 Feb 2025 09:56:05 AM

At the risk of sounding rude...

First, it looks like you don't want to remove only periods, but also the hyphen.

Second, what you are asking is extremely basic.

Doing your work for you won't help anyone. Not the person providing the answer, not your boss, but mostly not you. You need to take a basic SQL tutorial.

Title: Re: Replace a number with multiple dots stored in the database without dots
Post by: cognovice on 12 Feb 2025 10:41:10 PM

thanks

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: cognovice on 11 Feb 2025 05:28:43 PM