How to filter string

[Vincent_Nuestro]

Hi i need to filter out the address based on street, Suburb, State and Zip Code.
the highlighted blue is the address and the highlighted yellow is the expected output.

I already solve the street. my problem now is the Suburb, state and ZIP

thank you in advance
-Vincent

[Yoichi]

HI,

How about the following?

m = System.Text.RegularExpressions.Regex.Match(strAddress,"^(?<STREET>[^,]+),(?<SUBURB>.*) (?<STATE>\w+) (?<ZIP>\d+)$")

then

m.Groups("STREET").Value
m.Groups("SUBURB").Value
m.Groups("STATE").Value
m.Groups("ZIP").Value

Sample20230327-4L.zip (2.3 KB)

Regards,