+ Reply to Thread
Results 1 to 2 of 2

Extract 2, 3, 4 or 5-digit number from string

  1. #1
    Jim
    Guest

    Extract 2, 3, 4 or 5-digit number from string

    I have a list of URLs where some contain the parameter "categoryid="
    with either a 2, 3, 4, or 5 digit number. I need to extract that
    number, as an integer, into a neighboring column. I need a routine or
    function to help with this - something along the line of making the mid
    function smart enough to recognize numbers and adjust the length value
    so it only takes the numbers. And if it doesn't find "categoryid",
    then leave the cell blank.

    TIA,
    Jim


  2. #2
    Registered User
    Join Date
    12-22-2003
    Location
    Texas
    Posts
    90
    Jim,
    If the text string is in cell D6 - try this.

    =IF(ISERROR(SEARCH("categoryid=",D6)),"",MID(D6,SEARCH("categoryid=",D6)+11,LEN(D6)-SEARCH("categoryid=",D6)+11))

    This function assumes that the numbers are on the end of the text string. if there is a constant text ending - such as ".com" or something, simply subtract the length of that string ending from the mid function.
    Barrfly

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1