Get Directory and number in a string in an irregular expression

2

I have a table that has all the address in a single column, but it is irregular. Here are some of the following:

BR 459 KM 153
RODOVIA ITAJUBA MF KM 05
Rodovia MG353  2Km 55
RUA 37 QUADRA 4 LOJA 611 E 1621
Rua 13 de Maio 71C
RUA 106 Nº07
RUA 114 08

What is the most correct way to extract for these cases the Post and the Number jé that we have the name of the Street / Highway with number and other information that can be discarded? Thanks in advance.

    
asked by anonymous 14.05.2018 / 20:25

0 answers