Count substring if contains number?

[yaser]

Hello!

How can I count the number of substrings within a string, which contain numbers?

The following is what I am trying to get:

Address	Count
Outing Park 69 Oswego St Apt 1R	2
Outing Park 69 Oswego St Apt 1R	2
Austin Street Apt 810	1
O RUBIN COURT APT D7	1
HAMBLIN CT 23 E MAIN ST APT 1B	2
OLNEY ST APT 417	1

Thanks in advance!! 🙂

[CharlieS · Accepted solution]

I'm not the best at RegEx, but this should do the trick:

REGEX_CountMatches([Address],"\s*(\d+)\s*")

Use this as the expression in a Formula tool. Example attached. 

[yaser]

This works perfectly!

Could you please explain the expression?

Thanks!

[CharlieS]

Sure thing!

REGEX_CountMatches([Address],"\s*(\d+)\s*")

- RegEx_CountMatch( is an expression that counts the matches with [String] as defined by "RegEx" pattern.

- "\s*" is zero or more (*) space character (\s) and "\d+" is one or more (+) digit characters (\d). So the pattern is a digit character with a space on one side or another before another digit character occurs. 

This could use some more work because it has trouble with non-sequential digits since the spaces are optional. 

Edit: This works.

REGEX_CountMatches([Address],"\s*(\w*\d+\w*)\s*")

[yaser]

Nice!! thank you very much!!