AnsweredAssumed Answered

Parsing Text

Question asked by luisrosario on Dec 21, 2012
Latest reply on Dec 21, 2012 by luisrosario

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,

Outcomes