Finding array elements that include a specified combination of values?

1 次查看(过去 30 天)
I have the following problem. I need to match two sets of dates in two separate arrays, but the formats are different (YYYYMM & YYYYMMDD), and in one of the arrays the dates are randomly mixed.
So I'd need a way to refer to specific parts of an element. As I have the correct timeline with YYYYMM dates, the easieast thing would be to somehow require the beginning of the YYYYMMDD element to match YYYYMM?
Thank you so much in advance!

采纳的回答

Andrew Newell
Andrew Newell 2011-4-23
You can extract the parts of the date using
yourDate = '201105';
switch length(yourDate)
case 6
[Y,M] = datevec(yourDate,'yyyymm')
case 8
[Y,M,D] = datevec(yourDate,'yyyymmdd')
otherwise
error('Invalid date string length.')
end
Y =
2011
M =
5
The same sequence with yourDate = '20110514' gives
Y =
2011
M =
5
D =
14
  7 个评论
Anna
Anna 2011-5-1
Sorry for having bothered you, I managed to get around the problem by using the following code:
datum1=zeros(601,1);
datum2=zeros(601,1);
datum3=zeros(601,1);
for k=2:601
str= num2str(winners_aboveRF(k,1));
[Y,M,D] = datevec(str,'yyyymmdd');
datum1(k)=Y;
datum2(k)=M;
datum3(k)=D;
end
I know it's not classy, but it works, so I'm happy. If you however would happen to know a more elegant solution I'd be happy to hear it.
Thank you again for all your help!
Andrew Newell
Andrew Newell 2011-5-1
Are you sure that your code works? What do you get for Y and M if you type [Y,M,D] = datevec('201112','yyyymmdd')?

请先登录,再进行评论。

更多回答(0 个)

类别

Help CenterFile 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