Doesn't seem like many people are using the regular expression capability in
Excel. Some reason? Apart from the fact that it's kind of hard to figure
out? Actually, I'm trying to port some JavaScript regular expressions into
Excel... I think I've enabled the required library linkage, but I can't seem
to figure out the syntax required to refer to all of the lines in the
spreadsheet (which is really just a list of text strings). Don't seem to be
any good examples anywhere I can find them on the Web, and the Microsoft
documentation has been typically unenlightening.

Are the examples and useful instructions more liable to be found on the Word
side? Some of the later manipulations would be better with the spreadsheet's
capabilities, however.

Hi
post your current code which does not work

--
Regards
Frank Kabel
Frankfurt, Germany
"Shannon Jacobs" schrieb im Newsbeitrag
...
Doesn't seem like many people are using the regular expression capability
in
Excel. Some reason? Apart from the fact that it's kind of hard to figure
out? Actually, I'm trying to port some JavaScript regular expressions into
Excel... I think I've enabled the required library linkage, but I can't
seem
to figure out the syntax required to refer to all of the lines in the
spreadsheet (which is really just a list of text strings). Don't seem to
be
any good examples anywhere I can find them on the Web, and the Microsoft
documentation has been typically unenlightening.

Are the examples and useful instructions more liable to be found on the
Word
side? Some of the later manipulations would be better with the
spreadsheet's
capabilities, however.

Frank Kabel wrote:
Hi
post your current code which does not work
<old context snip

Well, I'd be willing to consider pasting in the code, but right now I can't
do it. I can't even tell for sure whether or not it is working. If it is
working, then Microsoft's implementation is incredibly bad and slow, which
would also explain why it seems that very few people are using the feature.
The current status is that I can't even get Excel's attention to ask it to
look at the code, but it's using 95% of the machine cycles and seems happy,
so I'm waiting to see what results come out, if any.

From memory I can say that I just defined a simple regexp, basically two
options before a short trailer string in the Pattern. Then I tried to invoke
a Replace on the Cells (just over 2000 in a single column), which did
nothing yesterday. Today I created an outer loop and tried to pass each cell
in individually--but I'm still waiting for it to finish or crash or do
something. About 10 minutes now, and still no results, and CPU still around
95%.

In yesterday's experiments I just zapped Excel at this point, and upon
restarting it would attempt to recover the file, but whether I used the
original saved file or the recovered version, in either case after that
Excel would not allow me to use any macros. The error message complained
about the security settings, but no matter what I did to the security
settings I could not get back into the file. Had to zot the file completely
each time and start from scratch.

Like they say: Microsoft's way or the highway.

There's a tutorial on the MVPS site. Word's regular expressions are pretty
well the same as any other, except that it uses minimal matching where unix
regex uses maximal.


"Shannon Jacobs" wrote in message
...
Doesn't seem like many people are using the regular expression capability
in
Excel. Some reason? Apart from the fact that it's kind of hard to figure
out? Actually, I'm trying to port some JavaScript regular expressions into
Excel... I think I've enabled the required library linkage, but I can't
seem
to figure out the syntax required to refer to all of the lines in the
spreadsheet (which is really just a list of text strings). Don't seem to
be
any good examples anywhere I can find them on the Web, and the Microsoft
documentation has been typically unenlightening.

Are the examples and useful instructions more liable to be found on the
Word
side? Some of the later manipulations would be better with the
spreadsheet's
capabilities, however.