fprintf multiple column string

I have imported a large file of numbers and letters into Matlab as a string. In short, after some number edits (which I know how to do), I am attempting to then use fprintf to save this to a new file. However, only the first column of the string is being saved. How do I save all the columns?

The input file and output file are shown in images.

Here is the code (the imported file is saved as variable S):

fileID = fopen('newfile.in','w');

fprintf(fileID, '%s\n', S);

fclose(fileID);

[Bob Thompson]

What file format is fileID?

I ask because fprintf() is intended to print strings out into a text or ascii format file, but your images appear to be almost an excel format. fprintf will not work properly printing to an excel file.

If that is a .csv file type then fprintf will work, but most likely still not properly delineate the different columns as it is intended to print single column lines of text, not string data to multiple columns.

Answer 1

[Steamboat Rock]

I figured out how to do it...

    for i=1:length(S(:,1))
        fprintf(fileID, '%s ',S(i,:)');
        fprintf(fileID,'\n');
    end

Cheers!