How to read and extract certain columns from a tenv3 file?
3 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Vikash Pandey
el 11 de Jun. de 2024
Comentada: Vikash Pandey
el 12 de Jun. de 2024
There are two aspects of the problem.
- How do I read a tenv3 data file? The source file can be found here.
- 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.
2 comentarios
Respuesta aceptada
Animesh
el 11 de Jun. de 2024
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 comentarios
Walter Roberson
el 11 de Jun. de 2024
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
Más respuestas (0)
Ver también
Categorías
Más información sobre Text Data Preparation en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!