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

1 次查看（过去 30 天）
Sonima
Sonima 2018-8-12
编辑： 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.

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

采纳的回答

Walter Roberson
Walter Roberson 2018-8-12
编辑：Walter Roberson 2018-8-12
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');
Note the order of inputs for ismember()

更多回答（0 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by