Print Page - How to filter items with "S" in the 3rd position?

Title: How to filter items with "S" in the 3rd position?
Post by: gatorfe on 20 Oct 2009 04:31:01 PM

What is the syntax I can use to filter items that have an 'S' in the third position? Thanks in advance for any suggestions.

Title: Re: How to filter items with "S" in the 3rd position?
Post by: cschnu on 20 Oct 2009 04:51:48 PM

I believe the function you are looking for is

substr([Package][View][Field], startposition, length) = 'S'

Title: Re: How to filter items with "S" in the 3rd position?
Post by: Gopinath on 21 Oct 2009 02:31:16 AM

Try

substring([Dataitem], 3, 1) = 'S'

COGNOiSe.com - The IBM Cognos Community