PROFESSIONAL NEWSGROUPS
WINDEV
,
WEBDEV
and
WINDEV Mobile
Home
|
Recent messages
|
Connect
|
Sign out
|
English
Home
→
WINDEV 2024
→
Exclude values in a filter
Exclude values in a filter
Started by Volker Gericke, Feb., 25 2024 2:52 PM - 2 replies
Connect yourself…
Volker Gericke
#1
Posted on February, 25 2024 - 2:52 PM
Hi,
The more I practice, the better the results... What a surprise!
I can INclude values in a string-based filter:
File.Filter("Name ~]' aaa ' OR Name ~] ' bbb '")
LOOP_File.Display()
This includes only records which contain a substring "aaa" or "bbb" surrounded by spaces.
I cannot find how to invert that - how to EXclude those records.
Any idea?
Kind regards,
Volker
Report
0
0
katherine KATHERINE
#2
Registered member
1 message
Posted on February, 27 2024 - 6:00 AM
Certainly! To exclude records that contain a substring "aaa" or "bbb" surrounded by spaces, you can use the NOT operator (~]!) along with the OR operator. Here's an example:
https://www.catneedsbest.com/
windev
File.Filter("NOT (Name ~]' aaa ' OR Name ~] ' bbb ')")
LOOP_File.Display()
This filter will retrieve records where the Name does not contain "aaa" or "bbb" as substrings surrounded by spaces. The NOT operator negates the conditions specified within the parentheses.
Report
0
0
Volker Gericke
#3
Posted on February, 27 2024 - 7:15 PM
Thank you Katherine, that‘s really cool.
Report
0
0
→ Go back to WINDEV 2024
WINDEV 2024
WEBDEV 2024
WINDEV Mobile 2024
WINDEV (earlier versions)
Français
English
Español
Portuguesa
Close this window
Search type
Only topics
All the messages
Search period
Any time
Past hour
Past 24 hours
Past week
Past month
Past year
Cancel
Preview of your message
Adding an image
Import an image from a URL
Send an image from a file of your disk
Drop a file or click "Browse..."
or
Cancel
0%
WLanguage
SQL
XML, HTML
JAVA, Javascript
Text