# How can I extract a specific row from a table?

1 view (last 30 days)
Ashfaq Ahmed on 6 Feb 2023
Commented: Voss on 6 Feb 2023
Hi all!
Suppose I have a table with two column (i.e., Date and Temperature) like this -
Please note that every date has multiple temperature assign to it. Now, I have another array that has three dates -
How can I extract these three days from the previous table with all the associated temperature? I mean, I want a matrix that will have these three dates with all the temperatures. Thus, 9 columns.

Voss on 6 Feb 2023
Edited: Voss on 6 Feb 2023
result = T(ismember(T.Date,Date_to_find),:)
result = 9×2 table
Date Temperature ____________ ___________ {'1/1/2021'} 1 {'1/1/2021'} 2 {'1/1/2021'} 3 {'4/1/2021'} 10 {'4/1/2021'} 11 {'4/1/2021'} 12 {'5/1/2021'} 13 {'5/1/2021'} 14 {'5/1/2021'} 15
Then, if you want those temperatures in a matrix with 9 columns:
result = result.Temperature.'
result = 1×9
1 2 3 10 11 12 13 14 15
##### 2 CommentsShowHide 1 older comment
Voss on 6 Feb 2023
You're welcome!