+ Reply to Thread
Results 1 to 5 of 5

VBA RegExp

  1. #1
    Forum Contributor
    Join Date
    10-01-2013
    Location
    Houston
    MS-Off Ver
    Excel 2010
    Posts
    136

    VBA RegExp

    Can someone explain to me the meaning of this RegExp (The red ones). The concept behind each one and what is going to be achieved with it:
    Please Login or Register  to view this content.
    Thanks for your time. Any good tutorial material or weblink on RegExp will be appreciated.
    Last edited by vnzerem; 02-11-2014 at 04:45 PM.

  2. #2
    Valued Forum Contributor bulina2k's Avatar
    Join Date
    11-20-2012
    Location
    Urziceni, Ialomita, Romania
    MS-Off Ver
    2019 and 365
    Posts
    861

    Re: VBA RegExp

    There you go!
    .. and don't forget to have fun!
    Bogdan.

    mark SOLVED and Add Reputation if my answer pleases you

  3. #3
    Forum Contributor
    Join Date
    10-01-2013
    Location
    Houston
    MS-Off Ver
    Excel 2010
    Posts
    136

    Re: VBA RegExp

    thanks a lot for the link

  4. #4
    Valued Forum Contributor bulina2k's Avatar
    Join Date
    11-20-2012
    Location
    Urziceni, Ialomita, Romania
    MS-Off Ver
    2019 and 365
    Posts
    861

    Re: VBA RegExp

    ^[^:] - doesn't starts with ":"
    +: repeats last char and then ":"
    *|; Matches the preceding character zero or more times OR ";"
    [^;] Matches any one of the enclosed characters
    +$ Matches the preceding character one or more times and matches the end of input.

  5. #5
    Forum Contributor
    Join Date
    10-01-2013
    Location
    Houston
    MS-Off Ver
    Excel 2010
    Posts
    136

    Re: VBA RegExp

    Thanks again...I really need to study more on regexp, to understand how to combined the characters

+ 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] RegExp function
    By pkiula in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-17-2013, 06:22 AM
  2. Error with Set RegExp equal to New RegExp vba
    By bdb1974 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 09-22-2011, 05:28 PM
  3. VBScript.RegExp
    By dschmitt in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 06-27-2010, 09:20 PM
  4. RegExp
    By YBrazeau in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-13-2010, 07:51 PM
  5. RegExp Pattern
    By MBCMDR in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-08-2009, 02:09 PM

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