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

4 views (last 30 days)
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.

Accepted Answer

Walter Roberson
Walter Roberson on 12 Aug 2018
Edited: Walter Roberson on 12 Aug 2018
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()

More Answers (0)

Categories

Find more on Tables in Help Center and File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!