COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: andoid95 on 10 Jun 2014 03:29:21 AM

Title: Parsing a column
Post by: andoid95 on 10 Jun 2014 03:29:21 AM
Hello,
I have a string column like  " Bonjour l'homme barbu " and i want to parse this colum for having  " Bonjour l''homme barbu " in order to use after replace function.
How to dit pls ?
:)
Title: Re: Parsing a column
Post by: bdbits on 10 Jun 2014 11:29:47 AM
There is a replace() function, but it is a database function and so support is somewhat dependent on database vendor. It looks to me like most of them do, what database are you using?