Reading columns of a .DAT file

5 次查看（过去 30 天）
Donrad
Donrad 2018-1-31
回答： Donrad 2018-1-31
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 个评论
Akira Agata
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?

请先登录，再进行评论。

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

采纳的回答

Walter Roberson
Walter Roberson 2018-1-31
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')
This might possibly lose the information about units.
Note that for the purposes of excel, you could just convert all the tab characters to commas and call that a .csv file.

更多回答（1 个）

Donrad
Donrad 2018-1-31
Thanks, both, I used the combination of both answers.

类别

在 Help Center 和 File Exchange 中查找有关 Data Import and Export 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by