Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
This is my regular expression:
lineRegEx.Pattern = " *([^ ]+) ?(.*) *" What I want is for it to strip leading and trailing spaces, and then split the remainder on the first space that it encounters. What it does in practice is to return the entire string as the first match. Any ideas what I'm doing wrong? I've tested it he http://www.regular-expressions.info/...ptexample.html ....and it shows the same behaviour, but the same pattern works he http://www.regular-expressions.info/...ptexample.html I can only assume that VBA is not using the regular expression implementation that I have been led to expect. Phil Hibbs. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
RegExp & VB Noob Qs | Excel Programming | |||
RegExp | Excel Programming | |||
RegExp information | Excel Programming | |||
RegExp - String in VBA | Excel Programming | |||
pattern matching w/o using VBScript's RegExp Object | Excel Programming |