add numbers in string

[billa856]

String=1000;200 0;3000;4000

how can i add this nos?

i need this
total = 1000+2000+3000+ 4000=10000

[missinglinq]

Assuming you have the Split() function available (I think it started with version 2000)

YourString ="1000;2000;3000;4000"
Nos = Split(YourString,";",-1)
YourTotal = val(Nos(0)) + val(Nos(1)) + Val(Nos(2)) + val(Nos(3))

Linq ;0)>

[billa856]

I found this one and its simple

Total = Eval(Replace(St ringName, ";", "+"))

[missinglinq]

Even better! Doug Steele is a slick fellow!

Linq ;0)>