+ Reply to Thread
Results 1 to 5 of 5

Using patterns - capture text after a string

  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"

    Please Login or Register  to view this content.

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

  2. #2
    Forum Expert WideBoyDixon's Avatar
    Join Date
    10-03-2016
    Location
    Sheffield, UK
    MS-Off Ver
    365
    Posts
    2,182

    Re: Using patterns - capture text after a string

    If you had the cell value in A1 then something like this:

    Please Login or Register  to view this content.
    WBD
    Office 365 on Windows 11, looking for rep!

  3. #3
    Valued Forum Contributor Haluk's Avatar
    Join Date
    02-14-2019
    Location
    Turkiye
    MS-Off Ver
    2010 - 64 Bit on Windows-11 (22 H2) 64 Bit
    Posts
    1,134

    Re: Using patterns - capture text after a string

    Alternative:

    Please Login or Register  to view this content.
    Last edited by Haluk; 02-25-2020 at 01:15 PM.

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

    Re: Using patterns - capture text after a string

    @WideBoyDixon and @Haluk. Both worked! Thank you!

  5. #5
    Forum Guru
    Join Date
    04-23-2012
    Location
    New Jersey, USA
    MS-Off Ver
    Excel 365
    Posts
    2,401

    Re: Using patterns - capture text after a string

    Do you really need to use Regular Expressions?

    If the search text is always located at the beginning of the cell text...
    Please Login or Register  to view this content.
    If the search text is not located at the beginning of the cell text...
    Please Login or Register  to view this content.
    Last edited by Rick Rothstein; 02-25-2020 at 04:18 PM.

+ Reply to Thread

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