separating day month year from string

1 view (last 30 days)
sermet
sermet on 7 Nov 2015
Edited: dpb on 8 Nov 2015
%I have a text file with one row and several hundreds columns. The text file includes string values like;
01.01.2013
02.01.2013
03.01.2013
%I need to read the text file and separate the day, month and year as numeric values like;
day=[01;02;03]; month=[01;01;01]; year=[2013;2013;2013]

Accepted Answer

dpb
dpb on 7 Nov 2015
Edited: dpb on 8 Nov 2015
[d,mo,yr]=textread('yourfile','%2d.%2d.%4d');
if were only that column. For more columns, use the proper format string for the line including whichever columns care to skip entirely and read into a cell array via textscan then convert per above format string using the particular cell column holding the dates. Have to convert the cellstr array to character array so use
damoyr=celltomat(textscan(char(c(N),'%2d.%2d.%4d'));
where N is the column of the above cell array returned containing the date string.
Or, if you have recent release, there's a date formatting string '%d' that will parse dates/times directly.

More Answers (0)

Categories

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

Community Treasure Hunt

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

Start Hunting!