HI

I am a list of addresses where I have to extract the locality only.Locality in Upper Case

For e.g

1. 12 Mahatma Gandhi st TRIOLET
2. Royal Road MON GOUT
3. ROCHE BOIS 12 Nicolay Road

Wish someone can help me find the result.

Thanks & Kind Regards