For 'readtable' func parameter 'Format' is not recognized although importing from a text

Question

Vasileios Leivadas 2018-7-9

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/409540-for-readtable-func-parameter-format-is-not-recognized-although-importing-from-a-text

回答： dpb 2018-7-9

   filename = fullfile('C:','Beacon_Data','FL-SB1_SensorTest_Data[1].txt');
   opts = detectImportOptions(filename);
   formatSpec = '%s%{dd-MM-yyyy HH:mm:ss}D%s%s%s%s%s%s%s%s';
   T = readtable(filename, opts, 'ReadVariableNames', false, 'Format', formatSpec);

Note that this is just the related segment of the code!

One row of the specified text file is as stated:

ID: FL-SB1-05; 05-07-2018 14:18:56; BatteryVol: 4117; T: 2909; Acc: -3949, 395, 759; Gyro: -149, 148, -136;

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

请先登录，再进行评论。

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

Answer 1

dpb 2018-7-9

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/409540-for-readtable-func-parameter-format-is-not-recognized-although-importing-from-a-text#answer_328150

在 MATLAB Online 中打开

As documented...

T = readtable(filename,opts,Name,Value) creates a table using the import options and with 
additional options specified by one or more of these name-value pair arguments: ReadVariableNames, 
ReadRowNames, DateLocale, Encoding, Sheet, and Basic.

'Format' is not one of the allowed name-value pair arguments when using an opts object; if you wish to use other than the detected variable type/format must change the opts object itself with the get/setvaropts pair.