How to import mixed date format into matlab

3 views (last 30 days)
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

Accepted Answer

Walter Roberson
Walter Roberson on 14 Apr 2018
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};

More Answers (0)

Categories

Find more on Dates and Time in Help Center and File Exchange

Tags

No tags entered yet.

Community Treasure Hunt

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

Start Hunting!