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

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.

Answer 1

[Bhaskar R]

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

[arifahazwani AY]

Thank you for your response.

If possible could you please share, how I can arrange this data in one data sheet?

Is it possible to extract only the 3 column of the text file?

Thank you in advance.!

[Bhaskar R]

% vertical concatanation
total_data = [FAM_data ;FCC_data ;FM2_data ]; 
total_data(:,[1, end]) = []; % remove first and coulmn as it has NaN values and only 0's 
% OR horizantal concatanation
FAM_data(:,[1, end]) = [];  % remove first and coulmn as it has NaN values and only 0's
FCC_data(:,[1, end]) = [];  % remove first and coulmn as it has NaN values and only 0's 
FM2_data(:,[1, end]) = [];  % remove first and coulmn as it has NaN values and only 0's 
total_data = [FAM_data ;FCC_data ;FM2_data ]; % vertical concatanation
% write data to excel file
writematrix(total_data, 'file_name.xlsx');

[arifahazwani AY]

Thank you very much for your response. but another problem is, the output is in 600x4 array, but I need to get 200x12 array, which the data need to be arranged next to each other.

Could you please help me on this?

Thanks again !

[Bhaskar R]

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]

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]

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.

[arifahazwani AY]

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.