how to filter particular set of dates from a column?

1 view (last 30 days)
how to filter particular set of dates from a column?
eg
if we have a column like this
19790914
19791219
19800310
19800622
....
20001231
how to remove/filter dates from 19800310 to 19901214. after this in this output how to add one date before 19800310?

Accepted Answer

KSSV
KSSV on 28 Oct 2021
Convert the dates to datenum and use logical indexing i.e. use inequalitties.

More Answers (1)

Walter Roberson
Walter Roberson on 28 Oct 2021
idx = find(19800310 <= column & column <= 19901214);
At this point you can select corresponding values by
selected_data = YourData(idx,:);
and you can reject corresponding values by
other_data = YourData; other_data(idx,:) = [];
If you are selecting and you want to add an entry before 19800310 then
selected_plus = [Additional_data; selected_data];
If you are rejecting and you want to add an entry where 19800310 would have been then
other_plus = [other_data(1:idx(1)-1, :); Additional_Data; other_data(idx(1):end,:)];

Community Treasure Hunt

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

Start Hunting!