find a string in a Date table column and return its index

Question

Sonima 2018-8-12

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/414578-find-a-string-in-a-date-table-column-and-return-its-index

编辑： Walter Roberson 2018-8-12

Hello! I have a table containing a Date column as the following:

 DTM15.Date(1:10,:)
 ans =
10×10 char array
    '2001-01-02'
    '2001-01-02'
    '2001-01-02'
    '2001-01-02'
    '2001-01-03'
    '2001-01-03'
    '2001-01-03'
    '2001-01-03'
    '2001-01-03'
    '2001-01-03'

I want to find a date in this column for example (2001-01-03) and return its index. I want to also find the first/last index if there are many of 2001-01-03 exist. Thanks.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2018-8-12

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/414578-find-a-string-in-a-date-table-column-and-return-its-index#answer_332503

编辑：Walter Roberson 2018-8-12

在 MATLAB Online 中打开

DTM15.Date = [
'2001-01-02'
    '2001-01-02'
    '2001-01-02'
    '2001-01-02'
    '2001-01-03'
    '2001-01-03'
    '2001-01-03'
    '2001-01-03'
    '2001-01-03'
    '2001-01-03']
[~, idx] = ismember(DTM15.Date, '2001-01-03', 'rows');
first_idx = find(idx, 1, 'first');
last_idx = find(idx, 1, 'last');