Hello, i have a list of adresses wich is driving me crazy.
in the same line i have the address, the district and the city, with different number of letter or words, the only thing i havo to help me is that the district is between hiffens "-", so i'm trying to separate the field filtering by the hiffens. but some thing is went wrong. the adress i can separate, like this:
Position (Adress; "-" ; 1 ; 1 )
How can i refer for the district, wich is between the hiffens? or refer to the city wich is after the second hiffen?
Is there any way to make a kind of calculation using the Position function, like Position 1 - Position 2 = something (it could be number of characters for the district.
an exemple of my adress list:
Adress - District - City
AV. CONSTANTINO STOCCO, 999 - VILA GUILHERME - SANTA CRUZ DAS PALMEIRAS
AV. LEÃO XIII, 9999 - RIBEIRANIA - RIBEIRÃO PRETO
AV. DR. JOSÉ C. MONTEIRO DA SILVA FILHO, 9999 - NOVA ALIANÇA - RIBEIRÃO PRETO
AV. JOÃO BATISTA DE OLIVEIRA, 850 - JARDIM SANTA JULIA V - ARARAQUARA
R. S. JOSÉ, 1111 - CENTRO - RIBEIRÃO PRETO
AV. PROF. JOÃO FIUSA, 00001 - ALTO DA BOA VISTA - RIBEIRÃO PRETO
thanks in advance,