Extract Zip Code from Address

[tjamal1]

Hello

I have few addresses like this 

3685 Flinton Road (GD ), Flinton, ON K0H 1P0

509 Bayly St E, Ajax, ON L1Z 1W7

80 Richmond St Unit 8, Amherstburg, ON N9V 1E9

,

I want to extract Zip Codes from them 

Like for above records it should be like 

1 KOH 1PO

2 L1z 1W7

3 N9V 1E9

How can i do this in Alteryx?

[OllieClarke · Accepted solution]

If the Zip code will always be the last two parts of the address, and will always be separated by a space then you can use the following regex

.* (\w+ \w+)$

[Aaron_Harter · Accepted solution]

@tjamal1 you can use RegEx to extract this info if it's in the middle of your text string, but if it's always the last 7 characters in the cell try the Right formula:

[tjamal1]

Thank for you reply,

Both Solutions worked for me 

[tjamal1]

Thank for you reply,

Both Solutions worked for me . Seems like i am getting the code in last for now