"Find" Options 1

[georgegee]

Hi All,

In the "Find Conditions" box, there is an operator: "Contains the character(s)".
Why is there not an operator: "Does *not* contain the character(s)"?
Or is there another way to find, to give the same result?

Many thanks,
George Gee.

 

[paulbent]

This type of find must be created on the view using a condition that contains the Position function. The find can be saved as a named find and you can create a variable field (option text) to enter the characters. Say the variable field is named vSearch. Create the named find as follows:

On a form based on the table to be searched, in Browse, from the menu, Create - Named Find/Sort - New - View. Click in any field from that table and enter this condition, substituting your own table name and name of field to be searched:

If(Position(Upper(Table.FieldName), Upper(vSearch), 1) = 0)

If the table or field name contains spaces it must be enclosed in quotes just like a calc field formula.

Then hit Enter, type a name for the Find and OK out. The find can be run from the Action Bar dropdown or the macro find command. You put the variable field on the form, enter the characters "not contained" in the variable field and run the find.

Paul Bent
Northwind IT Systems

http://www.northwindit.co.uk

 

[georgegee]

Paul,

Many , many thanks.
I would never have found that in a million years!
Your instructions were clear and lucid.
Again, thanks a lot.

George.