How convert cell array inside a cell array in a string with date and time format ?
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
Stefano Alberti
am 11 Feb. 2016
Kommentiert: Stefano Alberti
am 11 Feb. 2016
I've use this code to take a string like this: Daily_cum_2013_05_30_09_59__2013_05_31_10_05.asc and split it in two columns with only the numeric format (this a date and time).
sC = regexp(F, 'Daily_cum_', 'split');
sC = vertcat(sC{:});
sC(:, 1) = [];
sC = regexp(sC, '\.asc', 'split');
sC = vertcat(sC{:});
sC = regexp(sC, '__', 'split');
sC = sC(:,1);
Now I've a cells (4000x1) with inside a another cells (1x2).
How I can split this cells inside a string e convert to data and time format ?
Thanks
Stefano
0 Kommentare
Akzeptierte Antwort
Azzi Abdelmalek
am 11 Feb. 2016
F='Daily_cum_2013_05_30_09_59__2013_05_31_10_05__2013_05_31_10_08'
a=F(11:end)
b=regexp(a,'__','split')
out1=cellfun(@(x) datestr(datenum(x(1:10),'yyyy_mm_dd'),'yyyy/mm/dd'),b,'un',0)
out2=cellfun(@(x) datestr(datenum(x(12:end),'HH_MM'),'HH:MM'),b,'un',0)
out=[out1' out2']
4 Kommentare
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Cell Arrays finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!