COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: jd on 16 Apr 2010 10:53:44 AM

Title: help needed on using substring function
Post by: jd on 16 Apr 2010 10:53:44 AM
Hi,

how can I get first letter from N006187 number.

ex: From N006187, I need to show only N letter.

can I get any help on this??
Title: Re: help needed on using substring function
Post by: MFGF on 16 Apr 2010 11:24:48 AM
substring([your item],1,1)
Title: Re: help needed on using substring function
Post by: jd on 16 Apr 2010 11:58:22 AM
Thanks MFGF..