Borrar filtros
Borrar filtros

Nonstandard input date format into readstruct function?

9 visualizaciones (últimos 30 días)
Martin Ryba
Martin Ryba el 7 de Dic. de 2022
Comentada: Martin Ryba el 12 de Dic. de 2022
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?

Respuesta aceptada

Jeremy Hughes
Jeremy Hughes el 12 de Dic. de 2022
I believe this is a bug. I've created a bug report internally. Thanks.

Más respuestas (1)

Aylin
Aylin el 12 de Dic. de 2022
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 comentario
Martin Ryba
Martin Ryba el 12 de Dic. de 2022
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).

Iniciar sesión para comentar.

Categorías

Más información sobre Dates and Time en Help Center y File Exchange.

Etiquetas

Productos


Versión

R2022a

Community Treasure Hunt

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

Start Hunting!

Translated by