Searching with the variable "*"

Question

Good morning to all,

I am in the process of creating a report. I need to find in a huge table all the products that have numbers starting with *3211 and *2345, and under the * there can be hidden numbers 1,2,3,4, so I am interested in products starting with:
13211...
23211...
33211...
43211...

and
12345...
22345...
32345...
42345..
I currently manage to do this using the Filter tool. However, I wonder if it is possible to shorten the whole workflow significantly.

Could someone give me a hint as to whether it is possible to do something about it.

FinnCharlton · Accepted Answer

Hi @Luk88kk , you can use RegEx for this! In your filter tool, use the formula:

Regex_Match([Field],'\d3211\d*')
OR
Regex_Match([Field],'\d2345\d*')

The \d matches any digit 0-9, and the numbers match themselves. Hope this helps!

FinnCharlton · Accepted Answer

@Luk88kk In this case, we can make a slight change to the RegEx:

Regex_Match([Field],'\d*3211\d*')
OR
Regex_Match([Field],'\d*2345\d*')

This will now match any number containing the sequence '3211' or '2345'