Here is a test. I want to know the time of John when on the day I input. For example, I want output John’s time on the “2022-7-20”, which is “11:28”.
So I firstly filter the date, than filter the name. However, the result is Null.
Str=DT.Asenumerable.Where(Function(r) r(“Name”).Tostring.Equals(“John”) And Also r(“Time”).To string.Contains(YourStringinputDate)).Select(Function(r1) r1(“Time”).Tostring.Split(" "c)(1)).Last()
The file is only a test, actually I need to filter a lot of data, and I need to use “for each row” to get everyone’s right time on everyday. So are there any solutions using “filter”?