AnsweredAssumed Answered

How to sum tab-separated values?

Question asked by JavierDura on Aug 29, 2015
Latest reply on Aug 30, 2015 by okramis

Hi.

 

I have a text field with several numbers separated by tabs. Something like this:

 

1     3     4     5

2     5     6     8

1     2     3     5

 

and I want to get the sum of each column separated by tabs aswell:

 

4     10     13     18

 

Considering that:

- I don´t know in advanced the number of columns or the number of lines in the field

- every line will have the same number of values (4 values in the example)

 

...is it possible to get the result I need using a calculation (not an script)?

 

Thank you.

Outcomes