String convertion to date

5 次查看（过去 30 天）
Jorge Luis Paredes Estacio
评论： Jorge Luis Paredes Estacio 2023-2-7
Hello. I have the following strings
a= '16deNoviembredel2017'
b= '20:56:14'
I would like to convert the string into a specific date time format as indicated below
dt_event= datetime([a,b],'InputFormat','ddMMMMyyyyHH:mm:ss', 'Format','yyyy_MM_dd HH_mm_ss');
Could you please help me to correct the inputFormat to make it readable. Thank you.
Jorge
  4 个评论
显示 2更早的评论
Jan
Jan 2023-2-7
Then my question is: Can you ask the authors of these files to use a less obscure date format? Text files are wanted to be processable by code, so why deciding for a format which is hard to parse?
But I know: In many cases it is impossible to modifiy the inputs and the programmers have to live with strange data.
Jorge Luis Paredes Estacio
Jorge Luis Paredes Estacio 2023-2-7
Unfortunately, you can find that information like that from acceleration records and need to modify the scripts to verify the date before processing them.

请先登录，再进行评论。

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

采纳的回答

Jan
Jan 2023-2-7
Ran in:
a = '16deNoviembredel2017';
b = '20:56:14';
dt_event = datetime([a,b], 'Locale', 'es_ES', ...
'InputFormat', 'dd''de''MMMM''del''yyyyHH:mm:ss', ...
'Format','yyyy_MM_dd HH_mm_ss')
dt_event = datetime
2017_11_16 20_56_14
This works for this specific input, but are the keys "de" and "del" really fixed? I do not speak Spanish.

更多回答（1 个）

Benjamin Kraus
Benjamin Kraus 2023-2-7
编辑：Benjamin Kraus 2023-2-7
Ran in:
Note, I don't speak Spanish, so I'm not sure of the proper user of "de" and "del", so this answer may need to be adjusted.
I suspect you are going to need to manually remove "de" and "del" before you can use datetime. For example:
a = '16deNoviembredel2017';
b = '20:56:14';
a_ = regexprep(a,'(\d{2})de(\w+)del(\d{4})','$1$2$3')
a_ = '16Noviembre2017'
dt_event= datetime([a_,b],'InputFormat','ddMMMMyyyyHH:mm:ss', ...
'Format','yyyy_MM_dd HH_mm_ss','Locale','es_ES')
dt_event = datetime
2017_11_16 20_56_14

类别

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

标签

产品


版本

R2021a

Community Treasure Hunt

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

Start Hunting!

Translated by