Print Page - [SOLVED] Detail filter exclude based on part of string

Title: [SOLVED] Detail filter exclude based on part of string
Post by: Nickbruno on 27 Nov 2017 12:57:46 PM

Is there a way in the detail filter to exclude data from a list based on a string with in a string.

Basically want to do "contains" first four letters of a 20 character string& have it excluded from my results of those letters are contained in the string. Thanks

Title: Re: Detail filter exclude based on part of string
Post by: New_Guy on 27 Nov 2017 01:36:04 PM

Hi,
Create a data item with the substring([Your data item to filter],1,4). Use this in the filters as [Your data item to filter] <> 'ABCD'. ABCD are the first four letters of the strings that will be in [Your data item to filter] . Let us know if this resolved your issue.
Good luck
New guy

Title: Re: Detail filter exclude based on part of string
Post by: Nickbruno on 27 Nov 2017 02:04:56 PM

Worked like a charm New Guy. Thanks so much!

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Nickbruno on 27 Nov 2017 12:57:46 PM