tab delimited text file from matlab

13 views (last 30 days)
Richard
Richard on 24 Jan 2012
clear all
a = rand(131400,12);
DateTime=datestr(datenum('2011-01-01 00:01','yyyy-mm-dd HH:MM'):4/(60*24):...
datenum('2011-12-31 23:57','yyyy-mm-dd HH:MM'),...
'yyyy-mm-dd HH:MM');
DateTime=cellstr(DateTime);
header={'DateTime','temp1','temp2','temp4','temp7','temp10',...
'temp13','temp16','temp19','temp22','temp25','temp30','temp35'};
I'm trying to convert the outputs into one variable (called 'Data'), i.e. have header as the first row (1,:), 'DateTime' starting from row 2 (2:end,1) and running through each row, and finally having 'a' as the data (2:end,2:end) if that makes sense. So, 'DateTime' and 'header' are used as the heading for the rows and column respectively. Following this I need to save this into a tab delimited text file.
I hope I've been clear in expressing what I'm attempting.

Accepted Answer

Jan
Jan on 24 Jan 2012
Do you look for a function to write the tab-separated file?
a = rand(131400,12);
DateTime = datestr(datenum('2011-01-01 00:01','yyyy-mm-dd HH:MM'):4/(60*24):...
datenum('2011-12-31 23:57','yyyy-mm-dd HH:MM'),...
'yyyy-mm-dd HH:MM');
DateTime = cellstr(DateTime); % I assume it is a cell string already?!
header = {'DateTime','temp1','temp2','temp4','temp7','temp10',...
'temp13','temp16','temp19','temp22','temp25','temp30','temp35'};
FID = fopen(FileName, 'w');
if FID < 0, error('Cannot open file'); end
for i = 1:numel(DateTime)
fprintf('%s\t%g\t%g\t%g\t%g\t%g\t%g\t%g\t%g\t%g\t%g\t%g\t%g\t\n', ...
DateTime{i}, a(i, :));
end
fclose(FID);
  2 Comments
Richard
Richard on 24 Jan 2012
Although you didn't understand what I was asking, what you have shown works perfectly. thanks
wenwu xiu
wenwu xiu on 5 Mar 2012
Good response, but it seems that the header line is not inserted in the new File. How to do that, any ideas? Thx

Sign in to comment.

More Answers (0)

Categories

Find more on Dates and Time 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!