If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Strip of the frist 3 characters in a name

Started by lcarlos, 04 Sep 2009 09:48:24 AM

Previous topic - Next topic

lcarlos

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 ???

Naven

Hi,

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

Regards,
Naveen