How to convert a column date wich contains NaN?

14 次查看（过去 30 天）
Viridiana Torres
Viridiana Torres 2016-4-30
评论： Viridiana Torres 2016-5-1
HI!!
I hope you can help me to solve this doubt:
I have a column with number and NaN at the same time, lets say for example:
T= [199001021003.00;
199001021008.00;
NaN;
NaN]
The numbers are dates in the format yyyymmddHHMM and I want to convert those numbers into dates in Matlab format.
When I applied the next code:
D= datenum(num2str(T),'yyyymmddHHMM');
C= datestr(D,0);
It can´t recognize the NaN and therefore I have the next error:
"Error using datenum (line 179) DATENUM failed.
Caused by: Error using dtstr2dtnummx Failed on converting date string to date number"
How can I fix this and make Matlab doesn´t recogized the NaN and keeps giving the dates in Matlab format?
Thanks in advance!

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

采纳的回答

CS Researcher
CS Researcher 2016-4-30
You should remove the NaN entries first. DO this:
T(isnan(T)) = [];
D= datenum(num2str(T),'yyyymmddHHMM');
C= datestr(D,0);

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Dates and Time 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by