Clear Filters
Clear Filters

Info

This question is closed. Reopen it to edit or answer.

How to add new rows to text file with missing data?

1 view (last 30 days)
I have a txt file containing 4 tab delineated columns that are missing rows, like;
1, x, y, z
2, x, y, z
5, x, y, z
I am trying to write a script that will add the missing rows with the correct missing integer in the first column and and assign a 0 value to the other 3 columns, like;
1, x, y, z
2, x, y, z
3, 0, 0, 0
4, 0, 0, 0
5, x, y, z
What would be the easiest way to go about doing this?

Answers (1)

Azzi Abdelmalek
Azzi Abdelmalek on 4 Jul 2016
s=importdata('fic.txt')
out=zeros(s(end,1),4)
out(s(:,1),:)=s

This question is closed.

Products

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!