How to read and arrange certain data in multiple text file?

1 次查看（过去 30 天）
arifahazwani AY
arifahazwani AY 2020-3-11
评论： arifahazwani AY 2020-3-11
Hi,
I need to arrange the data after post-proceesing in text file and need to arrange the data in certain order. I only need the numerical part of the data. Any suggestion to solve this problem?
Attached herewith 3 text file of the data.

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

采纳的回答

Bhaskar R
Bhaskar R 2020-3-11
FAM_data = readmatrix('FAM.txt');
FCC_data = readmatrix('FCC.txt');
FM2_data = readmatrix('FM2.txt');
  5 个评论
显示 3更早的评论
Bhaskar R
Bhaskar R 2020-3-11
This part works for you
FAM_data = readmatrix('FAM.txt');
FCC_data = readmatrix('FCC.txt');
FM2_data = readmatrix('FM2.txt');
% OR horizantal concatanation
FAM_data(:,1 = []; % remove first and coulmn as it has NaN values and only 0's
FCC_data(:,1) = []; % remove first and coulmn as it has NaN values and only 0's
FM2_data(:,1) = []; % remove first and coulmn as it has NaN values and only 0's
total_data = [FAM_data ;FCC_data ;FM2_data ]; % horizantal concatanation
% write data to excel file
writematrix(total_data, 'file_name.xlsx');
arifahazwani AY
arifahazwani AY 2020-3-11
Its work!
This is the edted script I had used.
FAM_data = readmatrix('FAM.txt');
FCC_data = readmatrix('FCC.txt');
FM2_data = readmatrix('FM2.txt');
% OR horizantal concatanation
FAM_data(:,[1,2,end]) = []; % remove first,second and last column
FCC_data(:,[1,2,end]) = []; % remove first,second and last column
FM2_data(:,[1,2,end]) = []; % remove first,second and last column
total_data = [FAM_data,FCC_data,FM2_data]; % horizantal concatanation if vertical use (;) instead of (,)
% write data to excel file
writematrix(total_data, 'file_name.xlsx');

请先登录，再进行评论。

更多回答（1 个）

Peter O
Peter O 2020-3-11
编辑：Peter O 2020-3-11
This seems like a good opportunity to leverage MATLAB's table datatype:
https://www.mathworks.com/help/matlab/ref/table.html
Use readtable() to import your data and writetable() to spit it out in the correct column ordering (adding/removing columns as needed. Within writetable, if you specify the name-value pair "WriteVariableNames" and false, the output file will not contain the headers.
  1 个评论
arifahazwani AY
arifahazwani AY 2020-3-11
If possible could you please share the script? I already tried the readtable syntax but there is error. I need to arrange data in the three column of each text file in one sheet of certain order without the heading.
Thank you in advance for your respons.

请先登录，再进行评论。

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by