How To SUM data in CSV format

No

           10 20 10 30
           20 10 20 30
           10 10 10 20
           20 30 20 10

   Total = 60 70 60 90

Like This

is it possible ?

step 1 = Use Split at text block and split this text as \n then you get 4 items as list like this

(10,20,10,30 20,10,20,30 10,10,10,20 20,30,20,10)

step 2 = Use for each item loop and then use replacement block to replace all , to + of each item

2 Likes

image

I am trying to get result like this

ohh mean you need vertical sum

1 Like

yes and the data may be more

step 2 = again use Split at text block and split this text as then agin you got 4 items as list
like 1st item looking like this
(10 20 10 30)

sorry i don’t understand can U plz help me with my .aia file

SUM.aia (1.7 KB)

Does your problem solved or not?

Unfortunately problem not solved yet can U plz guide me

ok i am modifying this project as you want…

ok I M waiting for it

One option would be to create an extension to add the values ​​by column, although you can also apply block logic to reach the same result.

can U plz guide me the process ?

csv doesn’t matter here. this is a string expression. as described above, it is enough to translate values into arrays and perform operations on them. the method was described to you above.

yes sit its a string value but unfortunately I am not able to sum this data

See my answer here

Create a procedure
Use the for each item in list loop
And sum up item by item inside the procedure

Taifun

Thanks for your reply I got the solution

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.