reshaping 2 vectors of dates

2 次查看（过去 30 天）
antonet
antonet 2012-7-9
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 个评论
显示 3更早的评论
antonet
antonet 2012-7-9
编辑：antonet 2012-7-9
Ok! now. thank you
antonet
antonet 2012-7-10
could anyone help? Thanks alot

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Andrei Bobrov
Andrei Bobrov 2012-7-10
编辑：Andrei Bobrov 2012-7-10
variant use within regexprep
D = regexprep(D,'[a-z\-]','');
DD = regexprep(DD,'[ .a-zE]','');
  5 个评论
显示 3更早的评论
antonet
antonet 2012-7-10
wOw. YOU ARE THE BEST!
antonet
antonet 2012-7-10
编辑：antonet 2012-7-10
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'};

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Dates and Time 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by