find string

[DEVIMPLOY_Autom]

Hi,

I have an address, and I need to extract the State from it. The address is: Rua Caixas de Água x, 4710-915 Braga, Portugal. The State is variable, so I'll be recording different addresses, but I only need the address

[TeeSee1]

The following may work if the content of the address col meets certain conditions (i.e. the non state portion does not contain any of the state names)

INTERSECT(
 {// list all the states//},
 SPLIT(
  [address col], " "
 )
)

[DEVIMPLOY_Autom]

thanks, I thought it ... but there1s no list ... 

I thought about it, but there's no list.

But if it is the text that is after the space and before the comma?

[TeeSee1]

There are two commas. Is it always the case? Is the state the text between the last comma and the space preceding it?

Also, there is no list of the states in Spain like there are 50 states in the USA??

[AleksiAlkio]

Would it be enough to just read everything before the first comma?

[DEVIMPLOY_Autom]

I found a solution for the collumn Direccíon(Address Col)
I created two collums :
1°) Named column: estado1 INDEX(SPLIT([Dirección], ", "), 2)  
2°) Named collumn: State  index(split([estado1]),2) .

thanks to help me!