MATLAB Answers

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

2 views (last 30 days)
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 Comments

Sign in to comment.

Accepted Answer

Bhaskar R
Bhaskar R on 11 Mar 2020
FAM_data = readmatrix('FAM.txt');
FCC_data = readmatrix('FCC.txt');
FM2_data = readmatrix('FM2.txt');

  5 Comments

Show 2 older comments
arifahazwani AY
arifahazwani AY on 11 Mar 2020
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
Bhaskar R on 11 Mar 2020
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 on 11 Mar 2020
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');

Sign in to comment.

More Answers (1)

Peter
Peter on 11 Mar 2020
Edited: Peter on 11 Mar 2020
This seems like a good opportunity to leverage MATLAB's table datatype:
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 Comment

arifahazwani AY
arifahazwani AY on 11 Mar 2020
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.

Sign in to comment.


Translated by