How can you sum comma separated numbers within a string?
I have a string field in my data base. Examples are:
0;3;4;2;3;5;0
3;4;1;20;3;0;4
I want to create a field that shows the sum of this field.
Results:
17
35
Is there an easy way to do this?
0;3;4;2;3;5;0
3;4;1;20;3;0;4
I want to create a field that shows the sum of this field.
Results:
17
35
Is there an easy way to do this?
Spydergt
Are there always 7 numbers? If so it may be easy to break it down trimming to the commas in a formula.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Flawless... thank you!