splitting of address into multiple columns using REgex

[kafka_u21]

I have an address column which includes Address, city, state & zip all combined into single column as example below. I needed it to be split into multiple columns, one column each for Address, City, State, Zip. how can we use regex to solve this? #Designer 

1060 PARK AVE APT 11A,NEW YORK NY 10211,,

8061 PEACHTREE ROAD, N.W.,SUITE 101,ATLANTA GA 60321,

100 SOUTH POINTE BEACH, APT.205,MIAMI BEACH FL 33141,

1141 5TH AVE APT 2B,NEW YORK NY 10211,

[alexnajm]

This article details a good example that should work for you! https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Knowledge-Base/Tool-Mastery-RegEx/ta-p/376...

i would just replace [^\d]+ with [^\n]+ since you have one address that contains a number in the street address. 

[flying008 · Accepted solution]

Hi, @kafka_u21 

Like before way of parse:

^(.+?)(?=\,[A-Z])\,([[:alpha:]\s]+)\s([[:alpha:]]{2,})\s(\d{5})\,*$

[kafka_u21]

@flying008 thanks so much. you are the best. this works perfectly. any material to learn regex that you can share?

[flying008]

Hi, @kafka_u21 

Please see the post link as @alexnajm said. and you can try regex expression in www.regex101.com .