RegEx Match - Beginning of a line is a number

Question

Hello all,

I am trying to build a simple regular expression that lets me know if the first character is a number. For example, if the field contains "1 appraisal",  then I would have a match because it starts with "1" - a number. If the field contains "Annual Review 2," then there is no match because it doesn't start with a number.

I wrote this in a filter tool, Regex_Match ([field name], "[^\d]")

What am I doing wrong? I thought the ^ was for the beginning of a line, and the \d was for numerical values.

I appreciate your help!

binu_acs · Accepted Answer

@Kristie_Pires  [^d] - means match a single character not present in the field. ^\d indicating the start of the line, you can re-write the formula like below

REGEX_Match([Input], '^\d.*')

alexnajm · Accepted Answer

Try Regex_Match ([field name], "^\d.*")