Add zeros to some dates

Question

djr 2014-8-2

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/144476-add-zeros-to-some-dates

编辑： Andrei Bobrov 2014-8-2

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 个评论
显示 2更早的评论隐藏 2更早的评论

djr 2014-8-2

ki2_out_acyc.txt

Attached is the file. Dates are in the first column.

djr 2014-8-2

I need the following format:

000410 for April 10th, 2000.

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Azzi Abdelmalek 2014-8-2

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/144476-add-zeros-to-some-dates#answer_147197

在 MATLAB Online 中打开

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 个评论
显示 -1更早的评论隐藏 -1更早的评论

Azzi Abdelmalek 2014-8-2

在 MATLAB Online 中打开

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)

请先登录，再进行评论。

Answer 2

Andrei Bobrov 2014-8-2

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/144476-add-zeros-to-some-dates#answer_147199

编辑：Andrei Bobrov 2014-8-2

在 MATLAB Online 中打开

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));