Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I've read some posts about search strings but couldn't find the NOT operator.
I would like to write a searchstring when I try to select some values in a listbox:
(*XXX* & "NOT" *Archive*)
My goal is to select all values from the field "FolderPath" that contain the string "XXX" but NOT the string "Archive".
What is the correct syntax for this?
,Thanks in advance, Koen
Message was edited by: Koen Bal
=Field like '*XXX*' and not Field like '*Archive*'
Not sure I understand the requirement? Where are you using this?
Something like this ?
=if ( WildMatch ( 'BLAHappleBLAHlemonadeBLAH' , '*apple*' )
and not WildMatch ( 'BLAHappleBLAHlemonadeBLAH' , '*lemonade*' )
, 'Y' , 'N' )
=if ( WildMatch ( 'BLAHappleBLAHlemonadeBLAH' , '*apple*' )
and not WildMatch ( 'BLAHappleBLAHlemBLAHonadeBLAH' , '*lemonade*' )
, 'Y' , 'N' )
Test:
Load * inline
[
String_Field
ABCXXXDEFArchive
DEFArchiveABC
ABCXXX
XXXDEF
ABCXXXDEF
ArchiveABC
ABCArchive
];
Try the expression in list box: if(wildmatch(String_Field,'*XXX*') and not WildMatch(String_Field,'*Archive*'),String_Field)
Are you looking something similar to this?
List box has 3 values and when I give -WD, WD has been filtered out.
*XXX* & "NOT" *Archive* in same string?
Hi,
Try this
Search expression in listbox
Wildmatch(Filedname,'*XXX*') and not wildmatch(Fieldname,'*Archive*')
Try
("*XXX*" ^"*Archive*")
Never new about the ^ I'll remember that.
Thanks.
Doesn't seem to work...