Home |
Search |
Today's Posts |
#10
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
On Wed, 21 Apr 2010 05:47:20 -0700 (PDT), Phil Hibbs wrote:
Ron Rosenfeld wrote: If I might suggest: "^\s*(\S+)\s(.*?)\s*$" It wasn't the regular expression that was wrong, it's the way I was using the return value. But that's probably a better regex than mine. Phil Hibbs. OIC By the way, reading through some other messages in the thread, I was wondering about why you needed the LENgth calls? Is this for some subsequent processing of the outputs? Because if you just want to trim off leading and trailing spaces, that can be done with the regex. --ron |
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 |