Finding the index in the table with the incomplete input

1 view (last 30 days)
Hello,
my table has the entry of '2021-09-30 08:58:30.866' but I want to get its index just by finding with '2021-09-30 08:58:30.8'. When I used the find function, I couöldn't get the position of it just by writing '2021-09-30 08:58:30.8'.
Are there anyway to find the index with the incomplete input?

Accepted Answer

Star Strider
Star Strider on 19 Jan 2023
Are there anyway to find the index with the incomplete input?
Yes. However defining the threshold for the find argument may require a specific definition, since it depends on what the other values are in the vector, and what you are searching for.
Example —
DT = datetime(['2021-09-30 08:58:30.765'; '2021-09-30 08:58:30.866'; '2021-09-30 08:58:30.967'], 'Format','yyyy-MM-dd HH:mm:ss.SSS');
% DTsec = second(DT)
idx = find(second(DT) >= 30.8, 1, 'first')
idx = 2
Result = DT(idx)
Result = datetime
2021-09-30 08:58:30.866
.

More Answers (0)

Categories

Find more on Tables in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!