Print Page - Strip of the frist 3 characters in a name

Title: Strip of the frist 3 characters in a name
Post by: lcarlos on 04 Sep 2009 09:48:24 AM

The report has subtotals which is fine but the description for ex: says B&P HQ Labor and they want it to say HQ Labor, or OH-Int'l Medex and they want it to say Int'l Medex. I need to know how to write the expression for this request.
thx ???

Title: Re: Strip of the frist 3 characters in a name
Post by: Naven on 04 Sep 2009 10:03:06 AM

Hi,

You can use substr function, syntax is substr([Expression],5,n)

Regards,
Naveen

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: lcarlos on 04 Sep 2009 09:48:24 AM