reshaping 2 vectors of dates
1 visualizzazione (ultimi 30 giorni)
Mostra commenti meno recenti
Hi everyone
I have the following cell vector of dates
D={'September-October 2000' ...
'November-December 2000' ...
'January-Febraury 2001'...
'March-April 2001'...
'May-June 2001'};
Is there any way to change it to
D={'SO 2000' ...
'ND 2000' ...
'JF 2001'...
'MA 2001'...
'MJ 2001'};
Where as you can see I use only the first letter from each pair of months
The second cell vector of dates is the following
DD={ '4 Weeks Ending 24.09.00'...
'4 Weeks Ending 22.10.00'...
'4 Weeks Ending 19.11.00'...
'4 Weeks Ending 17.12.00'...
'4 Weeks Ending 14.01.01'...
'4 Weeks Ending 11.02.01'};
Is there a way to change it to
DD={ '4W240900'...
'4W221000'...
'4W191100'...
'4W171200'...
'4W140101'...
'4W110201'};
Where as you can see I merge number 4 with the first letter of the word ‘Weaks’ and the dates from which I omit the dot
cheers
5 Commenti
Risposta accettata
Andrei Bobrov
il 10 Lug 2012
Modificato: Andrei Bobrov
il 10 Lug 2012
variant use within regexprep
D = regexprep(D,'[a-z\-]','');
DD = regexprep(DD,'[ .a-zE]','');
5 Commenti
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Dates and Time 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!