Results 1 to 4 of 4

Thread: RegExpression

  1. #1
    Join Date
    Jul 2006
    Posts
    157

    Unanswered: RegExpression

    Hi:
    Can any one please tell me the regExpression. I try to do thru instr but the style of data is not same always. I need the number "894052" from this string thru regExpr

    strSubject="PPV / VOD Research - Dispute - 1st Time - 894052"

    NewValue = Mid(strSubject, InStrRev(strSubject, "-") + 2)

    Thank You.

  2. #2
    Join Date
    Aug 2002
    Location
    Northampton, England
    Posts
    266
    Is it always the last 6 characters?

  3. #3
    Join Date
    Jul 2006
    Posts
    157
    No it could be change.

    thanks.

  4. #4
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1

    Lightbulb

    I think you can make a loop for the whole string
    for i = 1 to len (yourString)
    Next

    Asking for each charcter whether it is numeric or not,
    if yes then store it in another string otherwise take the next letter.
    Hope that would help

Posting Permissions

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