Prev: template task pane opens when work book opens
Next: Format sheet based on column contents
From: Ron Rosenfeld on 21 Apr 2010 10:47
On Wed, 21 Apr 2010 05:47:20 -0700 (PDT), Phil Hibbs <snarks(a)gmail.com> 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
First  |  Prev  | 
Pages: 1 2
Prev: template task pane opens when work book opens
Next: Format sheet based on column contents