MATLAB: How to extract Jan and feb dates from an array of date strings

MATLAB

Hi,

I have an array of cells of date string. I need to extract all the dates in Jan and Feb. How to do that? Thanks a lot!

Best Answer

>> C = {'1/1/2018'; '2/1/2018'; '12/31/2018'};
>> X = cellfun('isempty',regexp(C,'^[12]/','once'));
>> D = C(~X)

Related Solutions

MATLAB: I want to split cell vector

Using datetime:

>> DT = datetime(date,'InputFormat','yyyy-MM-dd');
>> DT.Year
ans =
        1985
        1985
        1985
        1985
        1985
        1985
        1985
        1985
        1985
        1985
>> DT.Month
ans =
     1
     1
     1
     1
     1
     1
     1
     1
     1
     1
>> DT.Day
ans =
     1
     1
     1
     1
     2
     2
     2
     2
     3
     3

Or using regexp:

>> tkn = regexp(date,'^(\d+)-(\d+)-(\d+)$','tokens','once');
>> tkn = vertcat(tkn{:});
>> Y = tkn(:,1)
Y = 
    '1985'
    '1985'
    '1985'
    '1985'
    '1985'
    '1985'
    '1985'
    '1985'
    '1985'
    '1985'
>> M = tkn(:,2)
M = 
    '01'
    '01'
    '01'
    '01'
    '01'
    '01'
    '01'
    '01'
    '01'
    '01'
>> D = tkn(:,3)
D = 
    '01'
    '01'
    '01'
    '01'
    '02'
    '02'
    '02'
    '02'
    '03'
    '03'

MATLAB: Change timetable variable (working day to holiday)

Try this:

dd = datetime(2016,01,01):days(1):datetime(2016,12,31);                 % Create ‘datetime’ Array
workday = ones(size(dd(:)));                                            % Define Original ‘workday’
holiday = datetime({'2016-01-01','2016-03-25','2016-03-28','2016-05-01','2016-05-05','2016-05-10','2016-10-03','2016-12-25','2016-12-26'});
TT1 = timetable(dd(:), workday);                                        % Create ‘timetable’  Array
TF = ~ismember(TT1.Time,holiday);                                       % Compare ‘Time’ & ‘holiday’
TT1.workday = +TF;                                                      % The ‘+’ Converts ‘TF’ To Numeric

with:

First_5_Rows = TT1(1:5,:)

producinmg:

First_5_Rows =
  5×1 timetable
       Time        workday
    ___________    _______
    01-Jan-2016       0   
    02-Jan-2016       1   
    03-Jan-2016       1   
    04-Jan-2016       1   
    05-Jan-2016       1

Best Answer

Related Solutions

MATLAB: I want to split cell vector

MATLAB: Change timetable variable (working day to holiday)

Related Question