Re: Regular Expression

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

In article <1169507449.798703.102030@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>,
Shannon.Lieberg@xxxxxxxxx says...
So I am new to VB Macros in Excel and I swear I came across some method
called .contains where if a cell contained the string or regular
expression you were searching for it returned a boolean of True or
false if it didn't find it.

Now that I am returning to my notes I can't find it, nor can I find it
in books or on-line.

Has anyone heard of this or is there a better way to check if a cell's
contents conform to a particular pattern?

Thanks!


In addition to Harlan's suggestion, to use regular expressions in a UDF,
check
http://www.tmehta.com/regexp/
particularly
http://www.tmehta.com/regexp/add_code.htm

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
.

Relevant Pages

  • Re: Simple boolean expression evaluator
    ... >I am searching for a simple function that will take a string of boolean ... >expressions like: ... >And return a boolean result. ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: Why is A97 InStr FN returning True or False instead of a string?
    ... the string var assumes the Boolean value of True. ... The string segment I'm searching for is this... ...
    (comp.databases.ms-access)
  • Re: pumping lemma (third try)
    ... >> you a string not in L. ... >> contradiction and the proof that L isn't regular breaks down. ... > and answering my wannabe trials and questions. ... > there are no adjacent equal substrings. ...
    (comp.theory)
  • Re: [PATCH] nconfig: add search support
    ... and replace by a regular string search. ... From nconfig help: ... free terminal real-estate to display the match string was at the top ...
    (Linux-Kernel)
  • Re: pumping lemma (third try)
    ... some string x followed by its reverse.} ... > I will assume that L is regular and therefore the pumping lemma ... > Now I will divide the PL string w into the PL substrings x, ...
    (comp.theory)