LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #10   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,651
Default RegExp not matching what I want

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
RegExp & VB Noob Qs Ron Rosenfeld Excel Programming 2 June 28th 08 12:47 AM
RegExp Arshavir Grigorian Excel Programming 2 March 13th 08 12:55 AM
RegExp information Alain R. Excel Programming 1 February 18th 08 02:56 PM
RegExp - String in VBA MSK Excel Programming 0 July 24th 07 02:50 PM
pattern matching w/o using VBScript's RegExp Object Tim Williams Excel Programming 0 March 7th 05 09:19 PM


All times are GMT +1. The time now is 10:36 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"