How to select only rows that start without a number

[craigja]

I feel this is an easy one - I have a table of data and I want to filter out those rows that start with a number from those that start with letters - so keep the top 2 rows below:

BB_CASH_FLOW_251124.OUT
PROD_C_STUB_1_34233832
1732172458-11347118.OUT
1731684350-1292107460.OUT
1731924037-226881514.OUT
1730700008-113615882.OUT

[davidskaife · Accepted solution]

Hi @craigja 

Try this in the Filter tool

REGEX_Match([Field1],"^[[:alpha:]].*")

Alternatively you can replace [[:alpha:]] with \u if the letter is always uppercase

[craigja]

Excellent!  many thanks, can never get the hang of regular expressions!