$$Excel-Macros$$ Regex group capture

2010-05-19 Thread w.g.sned...@gmail.com
I am looking for syntax on how to capture a group in Excel I am using Excel 2002 and referencing MS VBScript Regular Expressions 5.5. my search string is this "10.10.10.132" my regExp.Pattern = "10\.10\.10\.(.*)" How would I get just the "132" returned? When I hit F1 for help I do not find anyt

Re: $$Excel-Macros$$ Regex group capture

2010-05-21 Thread w.g.sned...@gmail.com
nd If TestRegExp = RetStr End Function Bill On May 19, 3:01 pm, "w.g.sned...@gmail.com" wrote: > I am looking for syntax on how to capture a group in Excel > I am using Excel 2002 and referencing MS VBScript Regular Expressions > 5.5. > > my search string is this "