Calculating a text field

[tottijohn]

I have a text field which contains contents like "1A+22B-3C" or something like that. I created another number field so that i can get a sum of the text field, which will be "20" for the above example.

How can i go about doing that? I tried using the filter function in the number field;

Filter((text field);"0123456789+-*/")

but could only narrow it down to "1+22-3"

[The Shadow]

Just run Evaluate on the filtered result:

Evaluate( "1+22-3" )

will give 20.

[tottijohn]

How can i not think of such simple solution?

Gee thanks!