MATLAB Answers

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

4 views (last 30 days)
Sonima
Sonima on 12 Aug 2018
Edited: Walter Roberson on 12 Aug 2018
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 Comments

Sign in to comment.

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

  0 Comments

Sign in to comment.

More Answers (0)

Tags

Community Treasure Hunt

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

Start Hunting!