...
ALBANIA-(AL)
ALGERIA-(DZ)
ANDORRA-(AD)
ANGOLA-(AO)
ANGUILLA-(AI)
ANTARTIDE-(AQ)
ANTIGUA E BARBUDA-(AG)
ANTILLE OLANDESI-(AN)
ARABIA SAUDITA-(SA)
...
how to get the value between parentesys and store it in SIGLA?
note:
the length of state is variable
GET value between parentheses
-
- Administrator
- Posts: 78535
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: GET value between parentesys
Let's say you have the full text in a variable named NAZIONE.
SIGLA = Mid(NAZIONE, Len(NAZIONE) - 2, 2)
SIGLA = Mid(NAZIONE, Len(NAZIONE) - 2, 2)
Best wishes,
Hans
Hans
-
- PlatinumLounger
- Posts: 4362
- Joined: 26 Apr 2010, 17:36