add dd and mmm and time for matrix
2 views (last 30 days)
Show older comments
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.
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/155619/image.bmp)
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 Comments
Accepted Answer
Star Strider
on 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 Comments
More Answers (0)
See Also
Categories
Find more on Data Type Conversion in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!