Changing the Serial Date to String when saving as .txt file
1 visualizzazione (ultimi 30 giorni)
Mostra commenti meno recenti
I have a 20197x44 matrix where the first column is the serial date. I want to change the serial date to the format 'mmm dd, yyyy HH:MM:SS.FFF AM' when I am saving to a text file. (This data is for a client who has requested the date in this format).
I cannot figure out how to do this successfully. I have tried several approaches that are close but not working. I used a code to add column headers (shown below). Would I do something similar but use columns instead of rows?
% SAMPLE 1:
filename = 'Sample 1 Data.txt';
fileID = fopen(filename,'w+');
[rows, columns] = size(h1);
for index = 1:rows
fprintf(fileID, '%s,', h1{index,1:end-1});
fprintf(fileID, '%s\n', h1{index,end});
end
fclose(fileID);
dlmwrite(filename, rod1,'-append', 'delimiter', ',');
where h1 is the cell array of the column titles. Any suggestions greatly appreciated. Thank you
- Pamela
0 Commenti
Risposta accettata
Walter Roberson
il 6 Mar 2014
fprintf(fileID, '%s\n', datestr(h1(:,1), 'mmm dd, yyyy HH:MM:SS.FFF AM'))
The place it gets more complicated is if you want to put additional information on the same row and you want to do it all with one fprintf() instead of looping over the rows.
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Logical in Help Center e File Exchange
Prodotti
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!