Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default R: Basic regular expression question

hi everybody,
Alternatively you can try:

Sub foo_r()
Dim re As Object, mc As Object
Const sPat As String = "^[^\s]+|[^\s]+.+$"
Dim InputData(0 To 3) As String
Dim i As Long
Dim Results() As String

InputData(0) = "Item2 red notebooks"
InputData(1) = "Item2 notebooks"
InputData(2) = "I3 pens"
InputData(3) = "itm4 keyboards"

Set re = CreateObject("vbscript.regexp")
re.Pattern = sPat
re.Global = True

For i = 0 To UBound(InputData)
Set mc = re.Execute(InputData(i))
If mc.Count = 2 Then
ReDim Preserve Results(0 To 1, 0 To i)
Results(0, i) = mc(0)
Results(1, i) = mc(1)
End If
Next i

End Sub

regards
r
Reply
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
Basic regular expression question Robert Crandal[_2_] Excel Programming 4 April 17th 11 12:10 PM
Regular Expression Help on syntax Jason Excel Programming 25 January 10th 10 11:49 AM
Can someone help me with this regular expression? [email protected] Excel Discussion (Misc queries) 3 March 10th 09 07:36 PM
Help with regular expression PO Excel Programming 3 May 2nd 07 01:39 PM
Regular Expression sl Excel Discussion (Misc queries) 2 January 23rd 07 11:57 PM


All times are GMT +1. The time now is 07:45 PM.

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

About Us

"It's about Microsoft Excel"