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

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. 

20191211-RegExCountMatches.yxmd