Trouble when I try to set a macro expression

Question

I have this file:

...
stuff
...

1 4 1
1 3 4
1 3 5
1 3 6
2 1 3

I'd like to do the sum of these 3 number and put the result as 4th number, and I want to do this for each line.

To do that, I do this:

qq # I register a macro with q letter
"ay # I move to the first line and first number (1) and save it into a
"by # I do the same with number 4
"cy # and for the last number of the line, number 1
esc+i # I go to insert mode and move to the position where I want the sum
ctrl+r+= # to go to the expression mode
ctrl+r+a + ctrl+r+b + ctrl+r+c # to take the numbers from the registers and sum them and I have the correct sum result pasted
esc # to exit from insert mode
q # to save the macro

If I use it with @q for the other lines, it does not work, but if I do it with the same line that I used while recording the macro, it works, and pastes the same duplicate result:

1 4 11
1 3 4
1 3 5
1 3 6
2 1 3

What am I doing wrong?

Answer 1

Select the range of lines that you want to sum and run:

:'<,'>s/\v^(\d+ )(\d+ )(\d+)/\=submatch(1) . submatch(2) . submatch(3) . ' ' . (submatch(1) + submatch(2) + submatch(3))

NOTE: '<,'> it will be automatically placed by vim

Explanation:

\v ................. very magic search (avoid many backslashes)
^ .................. start of line
() ................. regex group
\d+ ................ one digit or more
\= ................. expression register
submatch(1) ........ repeats the first regex group