Skip to Content
0
Former Member
Sep 24, 2014 at 06:51 PM

logic of Find and Replace in Webi 4.0 ?

1314 Views

Hi ,

I have an concatenated object , and this concatenation is done at the universe side at a derived table .

following is the Syntx

p.firstname || ' '||p.surname || ' Lead'



now Lead is a text word that has been added ,


so in webi it looks like

Susanne Behr-Perst Lead



but i want two show brackets in the report like following


Susanne Behr-Perst (Lead)


how can i achieve this on webi ?