split numbers into coloumns

1 次查看（过去 30 天）
Sahar khalili
Sahar khalili 2022-12-12
评论： Jan 2022-12-12
Hello all
I have a raw of data with 16 digits like 0799569419940319, the last 8 digits are the year, the month and the day. How can I split the cells to extract the year and month and day?
  4 个评论
显示 2更早的评论
Star Strider
Star Strider 2022-12-12
Ran in:
Consider:
n = 0799569419940319;
ns = num2str(n);
dn = ns(end-7:end) % Date Segment
dn = '19940319'
nn = ns(1:end-8) % Number Segment
nn = '7995694'
DT = datetime(dn, 'InputFormat','yyyyMMdd') % 'datetime' Vector
DT = datetime
19-Mar-1994
I hav no idea what the rest of these numbers are, so I cannot generalise this and so am not posting this as an Answer.
.
Jan
Jan 2022-12-12
Ran in:
The leading zero let me assume, that this is not a number, but a CHAR vector. But if it is really a number:
n = 0799569419940319;
day = rem(n, 100)
day = 19
month = rem(floor(n / 100), 100)
month = 3
year = rem(floor(n / 10000), 10000)
year = 1994

请先登录，再进行评论。

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

回答（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