Results 1 to 5 of 5

Using patterns - capture text after a string

Threaded View

  1. #1
    Registered User
    Join Date
    10-31-2014
    Location
    Albany, New York
    MS-Off Ver
    2010
    Posts
    32

    Using patterns - capture text after a string

    It is my first time to use patterns for capturing objects.

    I cannot figure out what goes into the pattern in order to capture everything after "Details : Folders: ".

    Example:
    Cell value: Details : Folders: f1A795, f1B795, f2A795, f34955, fK683
    Output: f1A795, f1B795, f2A795, f34955, fK683


    My code below omits the first "f" and gives me this result: "1A795, f1B795, f2A795, f34955, fK683"

    Set r = CreateObject("VBScript.RegExp")
        r.IgnoreCase = True
        r.Global = True
        r.Pattern = "[\Details : Folders: ]+"

    Can you help?
    Last edited by mgcarino14; 02-24-2020 at 05:46 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to check if a string contains one of the patterns using And & Or in If statement
    By qzqzjcjp in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 09-03-2019, 06:14 PM
  2. Capture Query String From URL
    By bigscreentv1984 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-03-2017, 07:02 AM
  3. Finding Patterns in String of Text in One Column
    By HDTV in forum Excel General
    Replies: 3
    Last Post: 10-08-2014, 08:03 AM
  4. Need to capture date data in a text string containing a date and time stamp
    By Grilleman in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-07-2013, 01:14 PM
  5. capture browseforfolder in string
    By edjohns in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-29-2012, 01:32 PM
  6. Capture Only Numbers in a string
    By bconner in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-20-2008, 07:36 AM
  7. Capture right text string
    By andyp161 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-16-2007, 08:39 AM

Tags for this Thread

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