Regex to Parse City State

Question

Regex question.  I have city and state in a single field.  The comma is NOT always present, so I can't use that as a delimiter. City names can be 1-2 part names. State names are always 2-3 uppercase characters.

How can I regex this.

I need to use a parse tool.  This regex expression does not work:  ^.*?[A-Z]+

Field1CityStateLarapinta, Brisbane, QLDLarapinta BrisbaneQLDBlacktown Sydney NSWBlacktown SydneyNSWCoomera QLDCoomeraQLDManly Vale NSWManly ValeNSWWingfield SAWingfieldSA

philipmannering · Accepted Answer

You could use,

(.*),? (\u+)

in the Regex Tool (Parse Method). I believe that will do the trick.

philipmannering · Accepted Answer

Incidentally, your regex patter would have worked too if you add some parentheses and a $ sign.

^(.*?) ([A-Z]+)$

hen you Parse you always need to have a set of brackets to show what you're capturing. In the case above you're capturing everything up until a space and also capital letters at the end of your string. Don't forget to heed the case sensitivity checkbox.