slitting a number into year, mont and day

2 次查看（过去 30 天）
Johannes Deelstra
Johannes Deelstra 2013-4-19
I have a column(a(:,1)) containing numbers like;
19900101
19900102
19900103
19900104
19900105
19900106
19900107
19900108
19900109
19900110
The numbers represent year(1:4), month(5:6) and daynumber(7:8).
How to I split these numbers into year, number of month and daynumber?
Thanks
Johannes

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

回答（2 个）

Walter Roberson
Walter Roberson 2013-4-19
years = floor( a(:,1) ./ 10000);
months = mod( floor( a(:,1) ./ 100 ), 100);
days = mod( a(:,1), 100 );
  1 个评论
Jan
Jan 2013-4-22
I'd prefer this method, because it does not convert the numbers to strings and back to numbers again.

请先登录，再进行评论。

Daniel Shub
Daniel Shub 2013-4-19
It is not clear what your "a" is. If it is a numeric array
a = [ 19900101
19900102
19900103
19900104
19900105
19900106
19900107
19900108
19900109
19900110
];
you need to convert it to a char array
a = int2str(a);
Obviously if it is already a char array, you do not need to convert it. You then need to grab the sections you want, and possibly convert them back into numbers ...
year = str2num(a(:, 1:4));
month = str2num(a(:, 5:6));
day = str2num(a(:, 7:8));
  2 个评论
Johannes Deelstra
Johannes Deelstra 2013-4-22
Thanks very much Daniel and Walter, useful and very effective.
Walter Roberson
Walter Roberson 2013-4-22
If the problem is solved, please Accept an Answer.

请先登录，再进行评论。

类别

在 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