Extract row values from text file to add

I want to extract data from two different text files, textfile 1 and textfile 2 and do the following operation

row 1 =0.5*text file1(row1+row2))*(text file 2(row 2-row1))

row 2 = 0.5*text file1(row2+row3))*(text file 2(row 3-row2))+row1

For example,

row1=0.5*(5+8)*(9-6)

row2=0.5*(8+6)*(7-9)+19.5 and so on

the next value in the row should add the previously obtained sum (cummulative sum)

Values in text file 1 Values in text file 2 Expected output

5 6 19.5

8 9 5.5

6 7 -7.5

7 5 -12.5

3 4 -16.5

1 2

Is there a way to write a code without actually substituting the numbers and create a column that has the following output? All my data is in text files, so the code should extract the values from the text files and then do the calculation.

Thanks in advance

Answer 1

[Stephen23]

V1 = readmatrix('file1.txt')

V1 = 6×1

5 8 6 7 3 1

V2 = readmatrix('file2.txt')

V2 = 6×1

6 9 7 5 4 2

Z = cumsum(0.5*(V1(2:end)+V1(1:end-1)) .* diff(V2))

Z = 5×1

19.5000 5.5000 -7.5000 -12.5000 -16.5000

[BINCY BABU]

It worked. Thank you!!

Answer 2

[KSSV]

REad about the function load, it will load text file data into workspace; then use you formula on the arrays.

[BINCY BABU]

How do I represent the rows 1, 2, 3 and so on of the text file in my equation?