wildcards
allows Access to search for strings beginning with, ending with, or containing a given string.
Description
are used for 'string searching'. This allows searching for strings beginning with, ending with, or containing a given string.
Wildcard characters may be used to select item-ids and attributes based on common characters. Wildcards can be used in the selection criteria or in complex item.lists.
[ (left bracket). Matches characters following the bracket. Ignores characters in the string to the left of the bracket.
] (right bracket). Matches characters from the beginning of the string to the bracket. Ignores the characters in the string to the right of the bracket.
^ (caret). Matches any character in the position occupied by the caret. If both left and right brackets are used, the character string may appear anywhere in the attribute value. To select, sort, or list item-ids, a relational operator precedes the item-id containing the wild cards. Other attributes are identified by either their attribute number or their name as specified in the file dictionary attribute-defining item.
Example
list entity with name = 'sam]'
This lists any item whose 'name' field starts with 'sam'.
list entity with name = '[son'
This lists any item whose 'name' field ends with 'son'.
list entity with name = '[sam]'
This lists any item whose 'name' field contains 'sam'.
list entity with name = '[p^c]'
This lists any item whose 'name' field contains at least three
characters, beginning with 'p', and ending with 'c'. This
includes 'Pick Systems', 'Able Packing Co.' and
'Starving Movers, plc'.
See Also
User Comments
What do you think?
Share your experience or ask a question by using the form below.
Login to leave your comments.