Add ddmmm to the year column

1 次查看（过去 30 天）

显示更早的评论

Damith 2015-12-23

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/261515-add-ddmmm-to-the-year-column

评论： Walter Roberson 2015-12-24

采纳的回答： Andrei Bobrov

在 MATLAB Online 中打开

Hi,

I have a matrix "c" has year column and I need to add "31May" in front of each year in the column. So, the resulting array should look like below: (first two rows are shown). Note that years are not always in a sequence.

How can I achieve this in MATLAB.?

Thanks in advance.

31May1966      5261.9
31May1967      6003.5

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

采纳的回答

Andrei Bobrov 2015-12-23

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/261515-add-ddmmm-to-the-year-column#answer_204158

在 MATLAB Online 中打开

out = [arrayfun(@(x)sprintf('31May%d',x),c(:,1),'un',0),num2cell(c(:,2))];

4 个评论
显示 2更早的评论隐藏 2更早的评论

Damith 2015-12-24

xlswrite function worked here. But, when I open the file, the 1st column has dd-mmm-yyyy. There is a "-". Is there a way to specify the format of the 1st column?

Walter Roberson 2015-12-24

To check, are you writing a datenum (numeric value) to the column or are you writing a string like '31May1996' to the column?

http://www.mathworks.com/matlabcentral/answers/102670-how-do-i-identify-which-methods-and-properties-i-need-to-use-when-calling-excel-from-matlab-using-co

http://stackoverflow.com/questions/20648149/what-are-numberformat-options-in-excel-vba

请先登录，再进行评论。

类别

MATLAB Data Import and Analysis Data Import and Export Standard File Formats Text Files

在 Help Center 和 File Exchange 中查找有关 Text Files 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by