• GET part of string (2000)

    Author
    Topic
    #456832

    i have a var filled = 0900- xxxxxx (001) or filled 05680- xxxxxxxxxxx (011)…
    How to get only 0900- xxxxxx or 05680- xxxxxxxxxxx from the var?
    In effect i want to get all part of string without (xxx)…
    Note: the lenght of value nera (xxx) are variable but the suffix (xxx) have always the same lenght…

    Viewing 1 reply thread
    Author
    Replies
    • #1143160

      Let’s say the name of the variable is MyVar. To extract the part before the opening parenthesis ( you can use

      Left(MyVar, InStr(MyVar, “(“) – 2)

    • #1143285

      =Trim(Split(myVar,”(“)(0))

    Viewing 1 reply thread
    Reply To: GET part of string (2000)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: