[SOLVED] Detail filter exclude based on part of string

[Nickbruno]

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

[New_Guy]

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

[Nickbruno]

Worked like a charm New Guy. Thanks so much!