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

logic of Find and Replace in Webi 4.0 ?


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 ?