I’m using a regex to find bits of a string that indicate the “way” part of an address:
(?i)\b(ROAD|STREET|HILL|GREEN|AVENUE)\b
I want to count the number of those “way” indicators in a cell. I’m replacing with €, and then will count those. But I can only get one returned per cell.
I want the result A2=1, A3=3
Is there a fix, or should I try another way?
string | REGEX(cell,wayIndicatorRegex,€) |
---|---|
ROBERTS ROAD | ROBERTS € |
HILL GREEN ROAD | € GREEN ROAD |