A selection list in the software provides a list of the possible values for a cell
or field so you can easily pick a value. When you click in a cell with a selection
list available, the green arrow icon appears on the toolbar. You can use the Find box to search in the Selection list dialog box.
-
By default, the Find functionality searches across all columns.
-
The % wildcard is used to search for flexible patterns by representing zero or more characters in the string. The search is not case-sensitive.
-
Examples:
-
'%wght%300%' matches any value in the string that contains 'wght' followed by '300', with zero or more characters before, between, or after.
-
'%CABLE%' matches any value in the string that includes 'CABLE', with zero or more characters before or after.
-
-
-
'PLC%' matches any value in the string starting with 'PLC', followed by zero or more characters.