Summing Numbers in a Text Field

[Travis_Acrendo]

Does anyone know how to sum a group of numbers that are in a text field and separated by a carrirage return?

Example:

TextField1:

1

2

3

Calculation should result in 6.

Edited September 4, 2008 by Guest

[Colin Keefe]

How about

Evaluate(Substitute(data;¶;"+"))

[comment]

But the best way is to make them separate records.

[Travis_Acrendo]

Good idea, that will work!

Thank you!