Regex to Parse Data

[tahertalib]

Hi

I have data in the below format and want to split the data from right to left to get the below desired output:

Input Data

Bass Pro Mills Dr, Vaughan, ON L4K 5W4, Canada

Bowling Club, 12345 10 St NW, Edmonton, AB T6B 2W9, Canada

1055 S 43rd St, Grand Forks, ND 58201, USA

Output Data

Country	Postal Code	Province	City	Street Address	Other Data
Canada	L4K 5W4	ON	Vaughan	Bass Pro Mills Dr
USA	58201	ND	Grand Forks	1055 S 43rd St
Canada	T6B 2W9	AB	Edmonton	12345 10 St NW	Bowling Club

Could someone please let me know how can this be achieved through Regex? In my dataset i have a mix or Canada and US addresses.

Thanks

[Qiu]

@tahertalib 
RegEx will really depends the pattern of your data.

I have to assume, the fields are seperated by comma, and the Province is a two letter field.