Can a format string be supplied to detectImportOptions?
3 views (last 30 days)
Show older comments
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 Comments
Accepted Answer
dpb
on 10 Mar 2018
Use setvaropts to control properties associated with particular variables; specifically the DatetimeVariableImportOptions properties for datetime data.
0 Comments
More Answers (0)
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!