How to convert 'DDMMYYYYhhmm' into 'DD-MM-YYYY hh:mm'

7 次查看（过去 30 天）
Ali Saremi
Ali Saremi 2021-1-19
评论： Ali Saremi 2021-1-21
Hi there,
I have some data (Please see attached the screenshot) in an Excel sheet. I need to convert it into timeseries with two coloumns. Basically, the first coloumn should the date and the second coloumn should be the values. I was wondering if anyone could help me with this.
The data is formatted in two columns separated by a single space:
The first column is the datetime in the following format: 'DDMMYYYYhhmm'. 'DD' is the day of the month as a two digit integer 'MM' is the month of the year as a two digit integer 'YYYY' is the year as a four digit integer 'hh' is the hour of the day (using 24 hour time) as a two digit integer 'mm' is the minute of the hour as a two digit integer.
The second column is the water level reading in metres in the following format: 'si.fff'. 's' is a prefix indicating if the reading is positive or negative positive readings are denoted by a space ' ' negative readings are denoted by a dash '-'. 'i.fff' is the height of the recording in metres
For example, the line '190120380314 3.142' would refer to a height of 3.142 metres recorded at 03:14am on the 19th of January 2038.
Thank you.
Kind regards,
Ali
  2 个评论
Stephen23
Stephen23 2021-1-19
@Ali Saremi: please upload the original data file (not a screenshot) by clicking the paperclip button.
Ali Saremi
Ali Saremi 2021-1-19
@Stephen Cobeldick: Thank you for your reply. I have already uploaded the orginal data file. Look forward to hearing from you.

请先登录，再进行评论。

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

采纳的回答

Bjorn Gustavsson
Bjorn Gustavsson 2021-1-19
编辑：Bjorn Gustavsson 2021-1-19
You can do something like this to convert a date-string to another date-string:
datestr(datenum(char(['190120211029';'140219671940']),'ddmmyyyyHHMM'),'yyyy-mm-dd HH:MM')
You can of course replace '190120211029' with the string/char-array with your time instances.
HTH
  7 个评论
显示 5更早的评论
Bjorn Gustavsson
Bjorn Gustavsson 2021-1-20
Reading the help and documentation I learned that you can do something like this:
MeasurementTime = datetime(str2num(C_1(:,5:8)),... % Extract year
str2num(C_1(:,3:4)),... % month
str2num(C_1(:,1:2)),... % etc
str2num(C_1(:,9:10)),...
str2num(C_1(:,11:12)),...
zeros(size(C_1(:,11))));

请先登录，再进行评论。

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