How to read txt file usinig txtscan?

Question

Vishnu Dhakad 2020-2-28

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/508090-how-to-read-txt-file-usinig-txtscan

编辑： dpb 2020-2-28

Ahm-2019-VAAH.txt

I have read attached file which has 16435 rows but I have read only 385 row because column 7 has number and character.

how to read full file?

I have used following code

fedm = fopen('Ahm-2019-VAAH.txt');

VK = textscan(fedm, '%4s, %f-%f-%f %f:%f, %f, %f, %f, %f, %f, %f, %s','delimiter','\t','headerlines', 1);

fclose(fedm);

Thanks

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

dpb 2020-2-28

编辑：dpb 2020-2-28

No wonder it fails...the format string doesn't come close to matching that file and the delimiter is a comma, not tab.

However, it is badly formed with embedded spaces in non-quoted strings so will be tough w/ textscan

readtable with an import object as the other respondent showed is probably the way to go. It would be agoodthing™ if TMW would add the text import options object to textscan but don't suppose they ever will.

请先登录，再进行评论。

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

Answer 1

Ankit 2020-2-28

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/508090-how-to-read-txt-file-usinig-txtscan#answer_417773

编辑：Ankit 2020-2-28

在 MATLAB Online 中打开

Here you go:

% Create import options, tailor the data types for multiple variables, and then read the data
filename = 'Ahm-2019-VAAH.txt';
opts = detectImportOptions(filename,'NumHeaderLines',1); % Create import options based on file content
opts.VariableNamesLine = 1;
% now pass these opts to the readtable function
T = readtable(filename, opts,'ReadVariableNames',true);