Nonstandard input date format into readstruct function?

Question

Martin Ryba 2022-12-7

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1873212-nonstandard-input-date-format-into-readstruct-function

评论： Martin Ryba 2022-12-12

I have some XML files from another system and I want to be able to process the data therein. The readstruct function mostly fits the bill, but all the date/time fields get filled with "NaT" values because the input format isn't what datetime() expects and the Locale options aren't good enough. In particular, the input fomat is 'HH:mm:ss MM/dd/yyyy' which is I guess backwards from what datetime wants. The best option would be to add a "DateInputFormat" keyword to readstruct() that got passed as "InputFormat" to datetime(). Any other options?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Jeremy Hughes 2022-12-12

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1873212-nonstandard-input-date-format-into-readstruct-function#answer_1126477

I believe this is a bug. I've created a bug report internally. Thanks.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

Answer 2

Aylin 2022-12-12

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1873212-nonstandard-input-date-format-into-readstruct-function#answer_1126497

在 MATLAB Online 中打开

Thanks for reporting this.

There is an undocumented "DetectTypes" parameter on readstruct. Enabling this will read all XML nodes as either strings or missing values. This might help work around the issue for you.

>> type ans.xml
<A>
    <B>11:12:13 10/15/2022</B>
</A>
>> S = readstruct("ans.xml", DetectTypes=false)
S = 
  struct with fields:
    B: "11:12:13 10/15/2022"

Please note that this is an undocumented parameter, and may change in a future release.

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Martin Ryba 2022-12-12

Thanks, I ended up grabbing xml2struct from the File Exchange which does somthing similar, and pulling out and parsing the fields I needed by hand (giving datetime the InputFormat from the ICD used, and str2double most other places).

请先登录，再进行评论。