Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: gshilpa24 on 13 Jun 2012 10:46:09 AM

Title: Quick Help - Please help in the expression
Post by: gshilpa24 on 13 Jun 2012 10:46:09 AM
Hi,

I have a column called full_name
and the values are ,

CEI-Overall Statisfaction-T2B(DB)
CEI-Overall Statisfaction-T2B(DB/TEM)
CEI-Overall Statisfaction-T2B(HW)
CEI-Associate Service-T2B(DB)
CEI-Associate Service-T2B(DB/TEM)
CEI-Associate Service-T2B(HW)
Green Clients %(DB)
Green Clients %(DC/TEM)
Green Clients %(HW)

etc...

i have to extract only wat is there within the braces.

DB
DC/TEM
HW

please let me know how to extract only those with the help of substring.


data base is SQL Server 2008.

i also have another column against it without the DB, DC/TEM, HW


Title: Re: Quick Help - Please help in the expression
Post by: blom0344 on 13 Jun 2012 01:16:14 PM
Combine substring with position/posstr/pos  (can't recall how Cognos names this function) to check the position of  '(' and ')'
Title: Re: Quick Help - Please help in the expression
Post by: gshilpa24 on 13 Jun 2012 10:50:22 PM
Thank You for the response. I will try these functions.
Text only | Text with Images