add dd and mmm and time for matrix
2 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
Hi,
I have a file like this (see the attached csv file) but I need to include dd mmm yyyy in first column and (arbitrary time say 12:00) time in second column as shown in "output" below. How can I achieve this in MATLAB?
Any help is appreciated.
Thanks in advance.
output:
01 Jan 1990 12:00 203.03
01 Jan 1992 12:00 104.77
01 Jan 1993 12:00 46.156
01 Jan 1994 12:00 150.65
01 Jan 1995 12:00 75.323
.
.
0 Commenti
Risposta accettata
Star Strider
il 22 Feb 2016
You would have to use a cell array:
D = xlsread('Damith 150521.csv');
L = size(D,1);
Dv = [D(:,1) ones(L, 2) ones(L,1)* 12 zeros(L,2)]; % Date Vectors
Out = {datestr(Dv(:,1:6), 'dd mmm yyyy HH:MM') D(:,2)}; % Output Cell Array
celldisp(Out) % Display Output (Can Be Discarded)
6 Commenti
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Data Type Conversion in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!