Writing new column in Text file

11 views (last 30 days)
Muhammad
Muhammad on 27 Jan 2014
Edited: kjetil87 on 28 Jan 2014
I have 31 column in text file. I am trying to write new (32nd) column in existing text file. By using append the new column is placed at the end of text file. Any suggestions to write new column please...
  2 Comments
José-Luis
José-Luis on 27 Jan 2014
Edited: José-Luis on 27 Jan 2014
You need to import the whole file, append the data at the end of each line and then save it. Appending to the file is not going to do the trick.
Muhammad
Muhammad on 27 Jan 2014
Appreciated. How can I append the data at the end of each line? May be by for loop it is possible. Let consider I have a text file with 3x3 matrix; 7 3 3 2 3 4 5 4 2
and I would like to add a fourth column; 4 5 1 What do you suggest ?

Sign in to comment.

Sign in to answer this question.

Answers (1)

kjetil87
kjetil87 on 27 Jan 2014
As far as i know, there is no possability of writing in the middle of a file and have the rest of the data just shift along (correct me if im wrong).
So i guess your best choice here would be to read to old file into memory, append your new data to every line (so it will be a new column) and then overwrite the old file.
  3 Comments
Show 1 older comment
kjetil87
kjetil87 on 28 Jan 2014
Edited: kjetil87 on 28 Jan 2014
Hmmm, i guess fgetl would be usefull here.
fid=fopen('original.txt');
fidNew=fopen('newTxt.txt','w+');
newCol ='451';
cntr=1;
while(true)
line = fgetl(fid); %fgetl does not return the /n character
if line==-1 %line==-1 indicates end of file.
break;
end
fprintf(fidNew,line);
fprintf(fidNew,[' ',newCol(cntr),'\n'] );
cntr=cntr+1;
end
fclose(fid);
fclose(fidNew);
To do this without creating a new file, you must store line + the additional characters in e.g a cell matrix. Then close the old file, re open it using the 'w+' command and do another loop to write out the cell.
There might be alot of other ways to do this but atleast this way you can easily see what is actually being done.
Hope this gets you on your way towards what you need =)
kjetil87
kjetil87 on 28 Jan 2014
Edited: kjetil87 on 28 Jan 2014
On second thoughst, if you know that there is allways a matrix in the text file you can just use
contents = load('original.txt');
contents(:,end+1)=[4,5,1];
fid=fopen('original.txt','w+');
fprintf(fid,'%d %d %d %d\n',tt);
fclose(fid);

Sign in to comment.

Categories

Find more on Data Import and Export in Help Center and File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!