tab delimited text file from matlab

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.

 Respuesta aceptada

Jan
Jan el 24 de En. de 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 comentarios

Richard
Richard el 24 de En. de 2012
Although you didn't understand what I was asking, what you have shown works perfectly. thanks
wenwu xiu
wenwu xiu el 5 de Mzo. de 2012
Good response, but it seems that the header line is not inserted in the new File. How to do that, any ideas? Thx

Iniciar sesión para comentar.

Más respuestas (0)

Categorías

Más información sobre Data Type Conversion en Centro de ayuda y File Exchange.

Etiquetas

Preguntada:

el 24 de En. de 2012

Community Treasure Hunt

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

Start Hunting!

Translated by