Can I add new column (calculated from first column) to a text file ?
2 views (last 30 days)
Show older comments
Dear all, Please I have a text file has one column and many rows. I need to add new column which is calculated from the first column (the difference between the new set of rows and old set of rows which means the change in the first column. for example, the set of rows below consists from three rows each ( the first zeros should be for both columns).I need to apply this for the text file attached.
0 0
0 0
0 0
1 (1-0)
3 (3-0)
6 (6-0)
2 (2-1)
5 (5-3)
8 (8-6)
Many thanks
0 Comments
Accepted Answer
Star Strider
on 24 Feb 2016
This seems to do what you want:
B = load('ND B.txt', '-ascii');
New_Col = [B(4:end) - B(1:end-3); zeros(3,1)];
New_B = [B New_Col];
The last 3 rows of ‘New_Column’ I set to zero to make it possible to concatenate it with the existing ‘B’. You may want to append them to the beginning instead, or set them to NaN. The point is the columns have to have equal length to concatenate them.
8 Comments
Star Strider
on 5 Mar 2016
This is actually a new Question and should be posted as such.
Also, please give an example of what you want to do. Your description is not clear.
More Answers (0)
See Also
Categories
Find more on Data Type Conversion in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!