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

3 次查看(过去 30 天)
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;

采纳的回答

dpb
dpb 2018-7-9
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.

更多回答(0 个)

产品


版本

R2018a

Community Treasure Hunt

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

Start Hunting!

Translated by