Results 1 to 3 of 3

Thread: Extract name

  1. #1
    Join Date
    Apr 2002
    Posts
    168

    Unanswered: Extract name

    I have a text field which is like this :


    M1POST
    M12POST
    M256POST
    A12TMP
    ...

    So, in this example, I'd like to create a field which has :

    POST
    POST
    POST
    TMP
    ...

    So it extract the string after the number.



    Does anyone know how to do this ?


    Thanks

  2. #2
    Join Date
    Dec 2002
    Posts
    10

    Re: Extract name

    Since the len is not known before hand, you have to go the hard way:
    - go through the string char by char
    - mark the last char which is a digit
    - use it as a pivot point to extract the leftover

    Does it help at all or you need more specific?

    AL

  3. #3
    Join Date
    Apr 2002
    Posts
    168
    So,

    I need to use MID function to compare ?


    Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •