Add zeros to some dates

8 views (last 30 days)
djr
djr on 2 Aug 2014
Edited: Andrei Bobrov on 2 Aug 2014
Hi,
I have a file with dates that are in the format 'yymmdd'. For example, 991231 would be Dec 31st, 1999. However when it gets into 2000, the dates in the file are missing zeros before the first non-zero number. For instance, 410 stands for April 10th, 2000. Therefore, I have problems to cnevert it into the Matlab date format.
The file is in txt format so I opened it like this:
fid = fopen('ki2_out_acyc.txt');
acyc = textscan(fid, '%s');
fclose(fid);
The following functions do not work because it cannot recognize dates that are missing zeros:
ACdate = cellfun(@(x) datenum(x,'yymmdd'), acyc)
ACdata = datenum(acyc{1}, 'yymmdd')
ACdate = datenum(acyc{1})
I guess I have to add zeros to the dates that lack zeros. I have very large set of data so I cannot do it manualy.
Please could you help me with this? Thanks, Djordje
  4 Comments
djr
djr on 2 Aug 2014
Attached is the file. Dates are in the first column.
djr
djr on 2 Aug 2014
I need the following format:
000410 for April 10th, 2000.

Sign in to comment.

Accepted Answer

Azzi Abdelmalek
Azzi Abdelmalek on 2 Aug 2014
fid = fopen('file.txt');
acyc = textscan(fid, '%s');
fclose(fid);
w=cellfun(@(x) [repmat('0',1,6-numel(x)) x],acyc{:},'un',0)
ACdate = cellfun(@(x) datenum(x,'yymmdd'),w)
  1 Comment
Azzi Abdelmalek
Azzi Abdelmalek on 2 Aug 2014
acyc=dlmread('ki2_out_acyc.txt')
d=arrayfun(@num2str,acyc(:,1),'un',0)
w=cellfun(@(x) [repmat('0',1,6-numel(x)) x],d,'un',0)
ACdate = cellfun(@(x) datenum(x,'yymmdd'),w)

Sign in to comment.

More Answers (2)

Andrei Bobrov
Andrei Bobrov on 2 Aug 2014
Edited: Andrei Bobrov on 2 Aug 2014
out = datenum(cellfun(@(x)sprintf('%06s',x),acyc{:},'un',0),'yymmdd');
right variant
f = fopen('ki2_out_acyc.txt');
c = textscan(f,'%s %d %d %f %f %f %f %f','CollectOutput',1);
fclose(f);
out = datenum(cellfun(@(x)sprintf('%06s',x),c{1},'un',0),'yymmdd');
a1 = (out - now) > 0;
out(a1) = arrayfun(@(x)addtodate(x,-100,'year'),out(a1));

djr
djr on 2 Aug 2014
Thanks guys... Both answers worked. Thanks so much!!!

Categories

Find more on MATLAB 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!