MYSTRING="415063049-NAPOLI-(NA)"
How to get the value NA from braket ( )?
note:
the string have a dinamic lenght but the value in bracket is fixed from ( )
get value from ( )
-
- Administrator
- Posts: 78524
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: get value from ( )
Mid(MYSTRING, InStr(MYSTRING, "(") + 1, InStr(MYSTRING, ")") - InStr(MYSTRING, "(") - 1)
Best wishes,
Hans
Hans
-
- GoldLounger
- Posts: 2631
- Joined: 26 Jan 2010, 16:31
- Location: Southern California
-
- PlatinumLounger
- Posts: 4362
- Joined: 26 Apr 2010, 17:36