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

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?

2 Comments

Does the entire file fit comfortably in memory (RAM)?

Answers (1)

s=importdata('fic.txt')
out=zeros(s(end,1),4)
out(s(:,1),:)=s

This question is closed.

Products

Asked:

on 4 Jul 2016

Closed:

on 20 Aug 2021

Community Treasure Hunt

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

Start Hunting!