Regex expression to match the first digit of a number before any comma

[Bering]

Hello,

I need to find the position of the first digit in a formula (i.e. 4 in this example)

My formula was originally

='Fix fees'!D45

and regex.Pattern = "\d" would do the trick.

Now, my formula has changed to =ROUND('Fix fees'!D45,2)

and the above expression gives me 452

How can I fix it?

Many thanks!!

 

[Legacy 143009]

How about:

myDigit = CInt(Left(regex.execute(myFormula)(0), 1))

 

[Automatrix]

ChatGPT is good at writing regex code.

 

[Fluff]

@Automatrix please not Rule#17 regarding the use of AI sources for answering questions.

 

[Bering]

Thank you everyone.