Feedback by UserVoice

Patrick Matthews

My feedback

  1. 244 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Patrick Matthews supported this idea  · 
  2. 603 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Patrick Matthews commented  · 

    Expanding on this, Excel should be able to support the following regexp operations:

    1) Determine whether a source string matches a regexp pattern
    2) Return an array of regexp matches from a source string (or just the nth match)
    3) Return info on regexp matches within a source string, such as starting position and length of each match
    4) Return an array of regexp submatches from a source string (or just the nth submatch)
    5) Perform a find/replace operation on a source string based on regexp

    Please refer to this article:
    https://www.experts-exchange.com/articles/1336/Using-Regular-Expressions-in-Visual-Basic-for-Applications-and-Visual-Basic-6.html

    #1 and #2 in the list above can be handled with the RegExpFind UDF described therein
    #3 can be handled with RegExpFindExtended
    #4 can be handled with RegExpFindSubmatch
    #5 can be handled with RegExpReplace

    Patrick Matthews supported this idea  · 
  3. 12 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Excel for Mac » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Patrick Matthews commented  · 

    Expanding on this, Excel should be able to support the following regexp operations:

    1) Determine whether a source string matches a regexp pattern
    2) Return an array of regexp matches from a source string (or just the nth match)
    3) Return info on regexp matches within a source string, such as starting position and length of each match
    4) Return an array of regexp submatches from a source string (or just the nth submatch)
    5) Perform a find/replace operation on a source string based on regexp

    Please refer to this article:
    https://www.experts-exchange.com/articles/1336/Using-Regular-Expressions-in-Visual-Basic-for-Applications-and-Visual-Basic-6.html

    #1 and #2 in the list above can be handled with the RegExpFind UDF described therein
    #3 can be handled with RegExpFindExtended
    #4 can be handled with RegExpFindSubmatch
    #5 can be handled with RegExpReplace

    Patrick Matthews supported this idea  · 
  4. 811 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Great suggestion – thanks again for taking the time to put it on this site and for the thoughtful followup comments. This is pretty related to some other work we’ve got going and already has a fair number of votes, so we’ll work on getting plans in place now and hope to get started on this soon.

    Thanks,
    John [MS XL]

    Patrick Matthews supported this idea  · 

Feedback and Knowledge Base