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.