Print Page - is there an equivalent to Excel MID Function in RS?

Title: is there an equivalent to Excel MID Function in RS?
Post by: jmills on 28 May 2012 04:14:18 PM

I am trying to replicate a MID function from an excel report, and cant seem to find anything that compares... does Report Studio have a similar function?

I am trying to find the 3rd character in a string
In excel, the function looks like: =MID(A1,3,1)

Title: Re: is there an equivalent to Excel MID Function in RS?
Post by: Gyana on 28 May 2012 11:34:33 PM

substr ( [dataitem],3,1)

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: jmills on 28 May 2012 04:14:18 PM