Consulting

Results 1 to 5 of 5

Thread: Regular Expressions in Excel and Access

  1. #1
    VBAX Regular
    Joined
    May 2005
    Location
    Tallinn
    Posts
    26
    Location

    Regular Expressions in Excel and Access

    Hello.
    Where can i find good materials about using regular expressions in Excel
    and Access?
    What books can be suggested for beginner/proffessional in this area?

    I have book "Mastering Regular Expressions" (http://www.oreilly.com/catalog/regex/index.html), but
    this is mostly for Perl programming.

    J?ri.

  2. #2

  3. #3
    Knowledge Base Approver VBAX Expert brettdj's Avatar
    Joined
    May 2004
    Location
    Melbourne
    Posts
    649
    Location
    Hi Juri,

    My take is that there are 3 steps to conquer or at least get a working knowledge of RegExp

    1) Master the techniques in Excel to use the Execute, Test and Replace methods for vbscript regular expressions. Learn how to use submatches etc. Hopefully my example file that Zack linked to helps you with this
    2) Brush up on your pattern skills from O'Reillys book, websites such as the above, pattern testers etc. It doesn't matter too much if you learn from Perl, with some exceptions like lookahead functionality the patterns are interchangeable with vbscript. I picked up my understanding from a Perl help forum.
    3) Practice, practice, practice

    Cheers

    Dave

  4. #4
    VBAX Regular
    Joined
    May 2005
    Location
    Tallinn
    Posts
    26
    Location

    Thank You

    Thanks!

  5. #5
    VBAX Contributor
    Joined
    Oct 2004
    Posts
    159
    Location
    Regular Expression Laboratory is an assistant simple to use tool to help you learn and prepare regular expressions.

    http://www.silveragesoftware.com/rxl.html


    The Python Regular Expression Debugger

    http://kodos.sourceforge.net/

Posting Permissions

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