MATLAB Answers

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 件のコメント
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:
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.

サインインしてコメントする。

Community Treasure Hunt

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

Start Hunting!

Translated by