parsing the address data using alteryx

[kreemnadeem]

Greetings everyone,

I have a project where i am supposed to extract only the zip-code and state initials from the below data.

i have used the previous parsing formula but it didn't seem to work.

can someone please help me with this issue?

Thanking you in advance,

regards,

Nadeem

BELTMAN NORTH AMERICAN; -; 2480 LONG LAKE RD; ATTN MTCE SPARES; SAINT PAUL, MN; 55113-2534
ALBUQUERQUE MOVING AND STORAGE; -; 5001 PASEO DEL NORTE NE; ATTN: MTCE SPARES; ALBUQUERQUE, NM; 87113
A-1 LOGISTICS P & H DENVER; -; 11475 E 53RD AVE STE 180; ATTN: MTCE SPARES; DENVER, CO; 80239-2336

[LordNeilLord · Accepted solution]

Hey @kreemnadeem

Using the regex tool in parse mode try:

(\u{2};\s\d{5})

I think that should parse out what you need :)

Neil

[kreemnadeem]

Thank you so much @LordNeilLord, truly the lord i needed in the nick of time.
This is exactly what i was looking for. :D