- Import the file with xlsread (is that an xlsx?)
- Convert dates into serial dates
- Use logical indexing/ismember to locate the range of interest
- Again use logical indexing on 3rd and 4th column
matlab challenge- searching range of data to see if certain values exist
1 次查看(过去 30 天)
显示 更早的评论
please see the abov elink for a visual of my issue.. basically the values in the 3rd and 4th columns exist because there was an update. this is also because of both of the values of "0" in the 7th and 8th columns one row down. i need to be able to search a document for all instances where either of these occur, and i wanted to do this by choosing an interval time range of data from the 1st column and seeing if these values are what i am looking for. keep in mind that the actual data i have is long and there will be about 40 different cases of this. the end goal is to figure out all the times where this update occurs. any idea how to tackle this?? i am so stuck and any help at all would be much appreciated. thanks in advance.
0 个评论
回答(1 个)
Oleg Komarov
2011-5-18
0 个评论
另请参阅
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!