String convertion to date

Question

Jorge Luis Paredes Estacio 2023-2-7

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1907955-string-convertion-to-date

评论： Jorge Luis Paredes Estacio 2023-2-7

采纳的回答： Jan

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更早的评论隐藏 2更早的评论

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 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.

请先登录，再进行评论。

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

Answer 1

Jan 2023-2-7

2
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1907955-string-convertion-to-date#answer_1165530

在 MATLAB Online 中打开

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 个评论
显示 -1更早的评论隐藏 -1更早的评论

Jorge Luis Paredes Estacio 2023-2-7

Thank you very much. It works perfectly.

Best

Jorge

请先登录，再进行评论。

Answer 2

Benjamin Kraus 2023-2-7

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1907955-string-convertion-to-date#answer_1165550

编辑：Benjamin Kraus 2023-2-7

在 MATLAB Online 中打开

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