add dd and mmm and time for matrix

3 ビュー (過去 30 日間)
Damith
Damith 2016 年 2 月 22 日
コメント済み: Star Strider 2016 年 2 月 24 日
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
.
.

採用された回答

Star Strider
Star Strider 2016 年 2 月 22 日
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 件のコメント
Star Strider
Star Strider 2016 年 2 月 24 日
My pleasure.

サインインしてコメントする。

その他の回答 (0 件)

Community Treasure Hunt

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

Start Hunting!

Translated by