Upload text file and rearrange columns

2 次查看(过去 30 天)
HB
HB 2020-8-6
编辑: HB 2021-3-5
Hi,
I am trying to input the file attached titled "input_file.txt" into MATLAB and organise the content so as to output in the format as seen in "desired_output.xlsx".

回答(1 个)

Monisha Nalluru
Monisha Nalluru 2020-8-11
For loading the txt file into MATLAB, you can use importdata.
In order to process data into desired output, you can use split function which will be helpful to discard the sentence at required delimiter.
For writing the data to excel you can use writecell, writetable, writematrix depending on the way data is stored.

标签

Community Treasure Hunt

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

Start Hunting!

Translated by