MATLAB: How to convert matrix column into separate text

convert matrix column to separate text file with a name specifiermatrix to columnseparate column

Hi all, I have a 365*45 matrix, which represents one-year data for 45 subbasins. I would like to convert each column of the matrix to a separate text file (45 text file with a year data) and naming the file as subbasin_1, subbasin_2 etc. Any thought would be highly appreciated.

Best Answer

You obviously did not Google/Bing/Yahoo this.

You can use a loop, combined with sprintf to do this.

for n=1:45
    filename=sprintf('subbasin_%d.txt',n);
    fid=fopen(filename);
    %

    %put your writing code here
    %
    fclose(fid);
end

Related Solutions

MATLAB: Concatenate data using fgets

You are closing the file in the loop. close the file after the loop. I assume the below should work.

function read_datapattern(filename)
fid = fopen(filename,'rt');
if fid < 0
  error('error opening file %s\n\n',filename);
end
pattern = fgets(fid);
for n = 1:32767
  nextline = fgets(fid);
  pattern = strcat(pattern, nextline);
fprintf(pattern);
fprintf('\n');
end
fclose(fid);

MATLAB: Reading big textfile with textscan

Solution One

You do not need to delete the first ten rows from the file, because textscan has an option to ignore header lines, so you can use this instead:

Out = textscan(....,'HeaderLines',10);

To read 1280 columns of data you need to define this in the format string, so the final code could be something like this:

fmt = repmat('%f',1,1280);
fid = fopen('textfile.txt','rt')
out = textscan(fid, fmt, 'Delimiter',',', 'HeaderLines',10);
fclose(fid);

Solution Two

If the data in the matrix is all numeric (note the header lines do not need to be) then you could use the much simpler dlmread instead, something a bit like this:

out = dlmread('textfile.txt',',',10,0);

Examples

% textscan
fmt = repmat('%f',1,5);
fid = fopen('temp.txt','rt');
out_txt = textscan(fid, fmt, 'Delimiter',',', 'HeaderLines',3);
fclose(fid);
out_txt = cell2mat(out_txt)
% dlmread
out_dlm = dlmread('temp.txt',',',3,0)

display this in the command window:

out_txt =
     0     1     2     3     4
     5     6     7     8     9
out_dlm =
     0     1     2     3     4
     5     6     7     8     9

The sample text file that I used is attached here:

Best Answer

Related Solutions

MATLAB: Concatenate data using fgets

MATLAB: Reading big textfile with textscan

Related Question