separating day month year from string
1 visualizzazione (ultimi 30 giorni)
Mostra commenti meno recenti
%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]
0 Commenti
Risposta accettata
dpb
il 7 Nov 2015
Modificato: dpb
il 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.
0 Commenti
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Text Files in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!