Read Date time series format

13 次查看（过去 30 天）

显示更早的评论

Life is Wonderful 2019-8-17

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/476524-read-date-time-series-format

编辑： per isakson 2019-9-14

采纳的回答： Life is Wonderful

在 MATLAB Online 中打开

I want to read Date and time series from below format

   % file.txt has time formatted data
   [0803/135825.745523:GGBB:main.cc(182)] 
   [0803/135825.746634:NNFF:boat_control_xhramyos.cc(137)]
   % My Code is as follows   
    VariableNames          = {'Date'};                     
    VariableWidths         = [20] 
    VariableTypes          = {'datetime'};
    opts                   = fixedWidthImportOptions('VariableNames','SelectedVariableNames', [1]);
    opts                   = setvaropts(opts, 'Date', 'InputFormat', 'MMdd/HHmmss.SSSSSS');
    Content.update_engine  = readtable('file.txt', opts);

I am getting following error as I am unable to read the time properly.

Warning: Unable to convert one or more variables to datetime. Specify the correct
InputFormat and DatetimeLocale properties in the DatetimeVariableImportOptions. 
> In matlab.io.internal.functions.ReadTableWithImportOptionsText/executeImpl (line 82)
  In matlab.io.internal.functions.ReadTableWithImportOptions/executeImpl (line 18)
  In matlab.io.internal.functions.ReadTableWithImportOptionsText/execute (line 122)
  In matlab.io.internal.functions.ReadTableWithImportOptions/execute (line 25)
  In matlab.io.internal.functions.ExecutableFunction/validateAndExecute (line 98)

8 个评论
显示 6更早的评论隐藏 6更早的评论

Guillaume 2019-8-19

Can you please suggest someting else that is easy to do

Stick to one file format, the fixed width one in your previous question. Or use an even better one (e.g. comma delimited with text in quoted strings)

Otherwise, I'm afraid there's no easy way to do it. You'll have to use regexp or write your own parser.

Life is Wonderful 2019-8-19

OK if no other choices left .Can you please help me with sample script here

请先登录，再进行评论。

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

采纳的回答

Life is Wonderful 2019-8-20

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/476524-read-date-time-series-format#answer_388360

milliseconds information is in place(.SSSSSS)but conversion is not done properly.

2 个评论
显示无隐藏无

Walter Roberson 2019-8-20

在 MATLAB Online 中打开

The conversion looks perfect when I try.

timestamps.Format = 'dd-MMM-uuuu HH:mm:ss.SSSSSS';
>> timestamps(1:2)
ans = 
  1×2 datetime array
   03-Aug-2019 13:58:25.745523   03-Aug-2019 13:58:25.746634
>> S(1:100)
ans =
    '[0803/135825.745523:INFO:main.cc(182)] A/B Update Engine starting
     [0803/135825.746634:INFO:boot_cont'