清空筛选条件
清空筛选条件

Info

此问题已关闭。 请重新打开它进行编辑或回答。

Date(class:cell) type problem

1 次查看（过去 30 天）
Az
Az 2011-6-17
关闭： MATLAB Answer Bot 2021-8-20
I have cell array containing only dates(imported from excel) I want to change them into YYYYMMDD type. Datestr doesn't work and I tried cell2mat then datestr, but the result is quite wierd since many of the dates are missing from the result. I tried to export to excel to set the date type but some of them remain the same. So I am wondering how can I deal with this? driving me nuts. Thank you so much!

此问题已关闭。

回答（2 个）

Andrei Bobrov
Andrei Bobrov 2011-6-17
cellfun(@(c)datestr(c,'yyyymmdd'),cellarraydate,'un',0)
  2 个评论
Az
Az 2011-6-17
Dear andrei bobrov,
Thanks for your answer.
But it didn't work with my file.
Is there anyway I can Upload the file to you?
Anthony Smith
Anthony Smith 2011-6-17
datestr seems to only operate on strings so you probably need to access the contents of each cell individually rather than using an array operation. Using datestr format 29 for example:
for i=1:size(cellArray,1)
for j=1:size(cellArray,2)
newFormattedString = datestr(cellArray{i,j} ,29);
end
end
  1 个评论
Az
Az 2011-6-17
Dear Anthony Smith,
Thanks for your answer.
But it didn't work with my file.
Is there anyway I can Upload the file to you?

此问题已关闭。

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by