MATLAB: How to import mixed date format into matlab

Question

I have the following date columns parts of them: (yyyy mm dd) parts of them: (yyyy mmdd) parts them: (yyyymmdd)

I just want to import into matlab with separate columns of year, month, and days.

please have a look the textfile attached

Answer 1

fid = fopen('01643000.txt');
datacell = textscan(fid,'%8c%f%f%f%f%f', 'CollectOutput',true);
fclose(fid);
years = str2double(cellstr(datacell{1}(:,1:4)));
months = str2double(cellstr(datacell{1}(:,5:6)));
days = str2double(cellstr(datacell{1}(:,7:8)));
other_data = datacell{2};