Print Page - How to remove period from a string

Title: How to remove period from a string
Post by: JohnA on 06 Sep 2011 08:40:26 AM

I am needing to remove the period from a text string field
Ex: 123.45 or
V123.45

How would you simply display the result of: 12345 or V12345, with no period?
Thanks

Title: Re: How to remove period from a string
Post by: jive on 07 Sep 2011 09:14:37 AM

If you work with oracles you can used this function
SELECT REPLACE('V123.45
′,'.',") COL1 FROM DUAL;
result will be 'V12345'
In cognos I think the function SUBSTITUTE will do the same.

Regards Jacques

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: JohnA on 06 Sep 2011 08:40:26 AM