Ardmore2009-02-05 13:51:00
Halp! I need to get the regular expression (######).
I need one that will match an excel sum expression.
=SUM(A5:B5)
The letter could be anything from A-J, and the number 1-20...
I tried this: =SUM(()():()()) but when I do match it always comes back null. I can't figure this crap out! :crying:
I need one that will match an excel sum expression.
=SUM(A5:B5)
The letter could be anything from A-J, and the number 1-20...
I tried this: =SUM(()():()()) but when I do match it always comes back null. I can't figure this crap out! :crying:
Gwylifar2009-02-05 13:58:58
\\=SUM\\(?\\:?\\) should do it. Unfortunately it'll also match =SUM(A29:B29) but if regex can avoid that it's beyond my abilities. Note, this is untested, just off the top of my head.
