How To SUM data in CSV format

Anyone Please Help Me
data like this

10,15,35,25\n20,10,15,30\n10,20,40,30\n20,25,30,40

now I want to show index 2 column result

please help me


SUM.aia (1.7 KB)

Plz help me

where is column? that you want to show as index 2 columb result

10,20,10,30\n20,10,20,30\n10,10,10,20\n20,30,20,10 Like csv data and its Looks

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

You want to show this data?

like this

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.