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

Question

arifahazwani AY 2020-3-11

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/510231-how-to-read-and-arrange-certain-data-in-multiple-text-file

评论： 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.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Bhaskar R 2020-3-11

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/510231-how-to-read-and-arrange-certain-data-in-multiple-text-file#answer_419563

FAM_data = readmatrix('FAM.txt');
FCC_data = readmatrix('FCC.txt');
FM2_data = readmatrix('FM2.txt');

5 个评论
显示 3更早的评论隐藏 3更早的评论

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 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');

请先登录，再进行评论。

Answer 2

Peter O 2020-3-11

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/510231-how-to-read-and-arrange-certain-data-in-multiple-text-file#answer_419562

编辑：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 个评论
显示 -1更早的评论隐藏 -1更早的评论

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.

请先登录，再进行评论。