How in to parse constants in formula to cells
On Sun, 26 Nov 2006 13:38:01 -0800, PapaDos
wrote:
Like you said before, it is probably not possible to adjust it for every
circumstances (Average(1,2,3) and so on...).
But it should pick up the negative values !
Any example where it failed to do so ?
I didn't allowed spaces in my first version, this Regexp shoud fix that:
re.Pattern = "[=(^*/+\-]\s*(-*\s*\d*\.?\d+)"
On the OP's first example:
1 =687319 687319
2 +523187 523187
3 -7344000 7344000
4 +758450 758450
5 +2232642 2232642
6 +1995819 1995819
7 -2721538 2721538
8 +1491693 1491693
9 +723564 723564
10 *3 3
Note that the results or your routine are unsigned.
In my algorithm, I handled that problem differently, and so was able to retain
the negative signs.
1 687319
2 523187
3 -7344000
4 758450
5 2232642
6 1995819
7 -2721538
8 1491693
9 723564
10 3
--ron
|