find a string in a Date table column and return its index
2 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
Sonima
il 12 Ago 2018
Modificato: Walter Roberson
il 12 Ago 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 Commenti
Risposta accettata
Walter Roberson
il 12 Ago 2018
Modificato: Walter Roberson
il 12 Ago 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 Commenti
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Tables in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!