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

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.

Answer 1

[Walter Roberson]

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()