Can a format string be supplied to detectImportOptions?
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
I'm importing data from a text file and I'd like to do something like the following:
opts = detectImportOptions(filePath,'FileType','Text');
% manually change a couple of options
opts.DataLine = numHeaderLines + 1;
opts.Delimiter = {','};
% import
thisFile = readtable(filePath,opts,'Format','%{dd-MMM-yyyy HH:mm:ss.SSS}D%s%d');
However, I can't use the 'Format' Name-Value pair when passing opts to readtable as an argument. Is there any way to supply a format string in this situation?
0 Kommentare
Akzeptierte Antwort
dpb
am 10 Mär. 2018
Use setvaropts to control properties associated with particular variables; specifically the DatetimeVariableImportOptions properties for datetime data.
0 Kommentare
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Produkte
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!