Finding the index in the table with the incomplete input

Question

uzzi 2023-1-19

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1897130-finding-the-index-in-the-table-with-the-incomplete-input

评论： Star Strider 2023-1-20

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?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Star Strider 2023-1-19

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1897130-finding-the-index-in-the-table-with-the-incomplete-input#answer_1152130

在 MATLAB Online 中打开

‘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