Re: Specify Character Range in function parameter

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

aft3rgl0w wrote:

thanks for confirming that for me. do you have any examples of or know of
any websites with nifo on how to parse the test field or on the RegEx
function?

Parsing a string for that pattern could be along the lines
of this air code:

For k = 1 To Len(thestring) - 2
If Mid(thestring, k, 3) Like "##[a-h]" Then
strCycle = Mid(thestring, k, 3)
Exit For
End If
Next k

Regular expressions are a study topic all their own. There's
a lot of info at the microsoft web site (search for VBscript
RegExp). This might be a place to start:
http://support.microsoft.com/kb/818802
Note that most(?) things about VB6 also apply to VBA and I
am not sure where/what contains RegExp for Vista/A2007

--
Marsh
MVP [MS Access]
.

Relevant Pages

  • Re: Regexp as constraint on random string generator
    ... conforming to a certain pattern. ... easily described using a regexp, and it crossed my mind to ... the random construction of a string. ... beginning, and the array. ...
    (comp.lang.tcl)
  • Re: Help Optimizing Word Search
    ... and find all possible mutations that match a word in my ... For that size pattern and dictionary, ... a regexp, joining the dictionary together into one big string ("abc ...
    (comp.lang.python)
  • str.scan
    ... Regexp or a String). ... added to the result array or passed to the block. ... If the pattern ...
    (comp.lang.ruby)
  • Re: Making a group of objects up and down
    ... This string 'animate', will be parse and after that will be ... Every time this code is /parsed/, a RegExp object is created. ... Parses every time, and creates regexp when parsing. ...
    (comp.lang.javascript)
  • Re: Is it possible to convert ISO date format?
    ... Of course you could refine the pattern for also approximatively ... validating the input string to match YYYYMMDD-format. ... That would be rather silly, though, as it is so much nicer to use RegExp ... Dim s, dateIso, dateVal ...
    (microsoft.public.scripting.vbscript)