How do I filter out a column's item that start with alphabet letter?

Question

Hi community, I have a column example as follows:

I would like to filter out any items that is starting with alphabet letter,

What will be the formula?

Thank you

Order number1001-5211001-5235646-654AAAAS WEE REZ-FGG

caltang · Answer

@ryanzhang487

You can also try this:

REGEX_Match([Order number], "^[A-Za-z].*")

rzdodson · Answer

@Assuming the records you want always have a four digit prefix, followed by a hyphen, then followed by three digits, you can use Regex_Match in a filter tool to get the records you want.

SPetrie · Answer

A filter tool using REGEX_Match([Order Number],"\d.*")