Reading columns of a .DAT file

Question

Donrad 2018-1-31

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/379890-reading-columns-of-a-dat-file

回答： Donrad 2018-1-31

v1_Out-a.dat.zip

Hi All, I'm new to MATLAB and for my data processing, I need to read my data (format=float)from a .DAT file. This file contains 17 columns with close to 4000 rows (based on my experimental condition the # of rows can change), but always the two first rows are text formats (parameter name and then its units). Now I need to know how can I extract data with headers column-wise? I want to read each column and then write each of them into an EXCEL file.

Thanks

P.S: I found exactly the same question here , but no useful answers were provided

I have attached an example file

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

Akira Agata 2018-1-31

Looking at your data file, it seems that Import Tool would be easy and simple way to read. Have you ever tried this tool?

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2018-1-31

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/379890-reading-columns-of-a-dat-file#answer_302641

在 MATLAB Online 中打开

fid = fopen(v1_Out-a.dat', 'rt');
firstline = fgetl(fid);
varnames = regexp(firstline, '\t', 'split');
nvars = length(varnames);
units = regexp(fgetl(fid), '\t', 'split');
fmt = repmat('%f', 1, nvars);
data = textscan(fid, fmt, 'collectdata', 1);
fclose(fid);
datatable = array2table(data, 'VariableNames', varnames, 'VariableUnits', units);
writetable(datatable, 'NameOfExcelFile.xls')