can I do summation of two columns of a text file ?

Please I have a text file contains two columns. I need to sum them and write the result and the first coloumn in a new text file.

Like this : text.txt =

0 0

1 2

2 5

-1 -2

The new text contains the first and third column only

0 0

1 3

2 7

-1 -3

Thanks

Answer 1

[Geoff Hayes]

ND - you can try using uiimport to import the data from your text file into an appropriately named variable. When I tried this, using your sample data from above, I had to merge two of the cells to get -1. Once the data has been imported, you can then calculate the sum of the rows. For example, suppose the data is now in a variable as

 data =  [0     0
          1     2
          2     5 
         -1    -2];

You can determine the sum of each row as

 rowSums = sum(data')';

You can then use save or fprintf to write the first column of data and rowSums to file.

[ND]

Many thanks

I managed to do it like below,

 data = dlmread('dd.txt');
 rowsum = sum(data);
 bb = [data(:,1) rowsum];
 dlmwrite('dc.txt', bb)