There are two wildcards: _
and %
An underscore (_) matches any single character.
A percent sign (%) matches any sequence of zero or more characters.
For example, let's take the following list:
50$ discount
50% discount
No discount
If you apply a filter with:
match: 'like',
values: ['50%']
It will return not 1 but 2 rows:
50$ discount
50% discount
That is because %
is a wildcard for a sequence of zero or more characters. In order to make it return only 50%
discount , you will need to add an escape character ^
before the wildcard to filter for the value like so:
match: 'like',
values: ['50^%']
Also, given that the ^
character is an escape character there may be situations where you need to search for the string containing the ^
character. In these cases, (e.g. if you’re looking to filter for 50^
) it should also be escaped like so:
`match: ‘like',
values: ['50^^']