Formula Find/Select, OR, gutted

I designed my product codes such that the 4th character represents the unit size. In Pan 6 I could select CODE[4,4] = “U” for my bunched products. Also, Pan 6 Selection dialog allowed selections criteria using both AND and OR, like CODE beginswith “A” OR CODE beginswith “B” to select both baby and full sized lettuces.

To get the equivalent of OR, use “ANY of the following are true.”


To get the equivalent of AND, use “ALL of the following are true.”

To do a formula find select, use “Formula is true” in the regular Find/Select dialog.

Another good technique is to create a temporary procedure with code something like this:

select CODE[4,4] = "U"

or like this:

select CODE beginswith "A" or CODE beginswith "B"

You can use any formula you want that produces a boolean result.