Can a format string be supplied to detectImportOptions?

1 次查看（过去 30 天）
Daniel Murphy
Daniel Murphy 2018-3-9
回答： dpb 2018-3-10
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?

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

采纳的回答

dpb
dpb 2018-3-10
Use setvaropts to control properties associated with particular variables; specifically the DatetimeVariableImportOptions properties for datetime data.

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by