清空筛选条件
清空筛选条件

How to read and extract certain columns from a tenv3 file?

6 次查看（过去 30 天）
Vikash Pandey
Vikash Pandey 2024-6-11
评论： Vikash Pandey 2024-6-12
There are two aspects of the problem.
  1. How do I read a tenv3 data file? The source file can be found here.
  2. I wish to extract the data under the 4th, 9th, 11th, and 13th column, such that the first row of the extracted data should read,
" 54847 -1.187879 0.058425 0.879526".
Also can these be stored in the form of an excel file or a txt file?
Please help.

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

采纳的回答

Animesh
Animesh 2024-6-11
Hi @Vikash Pandey,
Unfortunately, MATLAB does not recognize the '.tenv3' file extension. However, a workaround is renaming the file extension to '.txt', which enables the usage of MATLAB's standard commands to manipulate the table and achieve the intended results.
Below is an illustrative example on how to manage a '.txt' file format:
data = readmatrix('your_data_file.txt');
% Extract the 4th, 9th, 11th, and 13th columns
extracted_data = data(:, [4, 9, 11, 13]);
% Display the first row of the extracted data
disp(extracted_data(1, :));
To save the extracted data to an Excel file, you can use the writematrix function:
% Save the extracted data to an Excel file
writematrix(extracted_data, 'extracted_data.xlsx');
And to save it as a text file:
% Save the extracted data to a text file
writematrix(extracted_data, 'extracted_data.txt', 'Delimiter', ' ');
  4 个评论
显示 2更早的评论
Walter Roberson
Walter Roberson 2024-6-11
@Vikash Pandey
writematrix(Extracted_Data, '~/Desktop/Work/Extracted_Data.xlsx')
for Mac and Linux.
For Windows, finding the Desktop folder is a bit more complicated.
profold = fullfile(getenv('USERPROFILE'), 'Desktop', 'Work');
writematrix(Extracted_Data, fullfile(profold, 'Extracted_Data.xlsx'));
However I do not promise that this will work if the Desktop has been moved to OneDrive

请先登录，再进行评论。

更多回答（0 个）

类别

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

标签

产品


版本

R2023a

Community Treasure Hunt

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

Start Hunting!

Translated by