reshaping 2 vectors of dates

1 Ansicht (letzte 30 Tage)
antonet
antonet am 9 Jul. 2012
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 Kommentare
3 ältere Kommentare anzeigen
antonet
antonet am 9 Jul. 2012
Bearbeitet: antonet am 9 Jul. 2012
Ok! now. thank you
antonet
antonet am 10 Jul. 2012
could anyone help? Thanks alot

Melden Sie sich an, um zu kommentieren.

Melden Sie sich an, um diese Frage zu beantworten.

Akzeptierte Antwort

Andrei Bobrov
Andrei Bobrov am 10 Jul. 2012
Bearbeitet: Andrei Bobrov am 10 Jul. 2012
variant use within regexprep
D = regexprep(D,'[a-z\-]','');
DD = regexprep(DD,'[ .a-zE]','');
  5 Kommentare
3 ältere Kommentare anzeigen
antonet
antonet am 10 Jul. 2012
wOw. YOU ARE THE BEST!
antonet
antonet am 10 Jul. 2012
Bearbeitet: antonet am 10 Jul. 2012
just a small question. In case some dates are empty how can i modify these codes?
FOr instance
D={' ' ...
'November-December 2000' ...
'January-Febraury 2001'...
'March-April 2001'...
'May-June 2001'};
DD={' '...
'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'};

Melden Sie sich an, um zu kommentieren.

Weitere Antworten (0)

Kategorien

Mehr zu Dates and Time finden Sie in Help Center und File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by