I want to export 5 columns from a huge text file with 16 columns and save it as a text file again

1 view (last 30 days)
I want to export 5 columns from a text huge text file with 16 columns and save it as a text file again. Can someone help me what function can I use for that. I will appreciate any help in this regards.
  1 Comment
yatharth
yatharth on 22 Jun 2022
Edited: yatharth on 22 Jun 2022
Hey , since you are reffering to columns I assume you have .csv instead of a .txt file , you can simply read the file and store it in a table and extract your desired columns either by column name (y) or by indexing (x) and later save it again as csv via writetable function
trainDataFileName = 'training.csv';
trainData = readtable(trainDataFileName);
y = trainData( : , ["Arch" "CTB" "Direct" "EntireTestName"])
x = trainData(: , 1:5)
writetable(x,'filename.csv')
you can reffer to readtable and writetable from the MATLAB Documentation

Sign in to comment.

Answers (1)

yatharth
yatharth on 27 Jun 2022
Hey , since you are reffering to columns I assume you have .csv instead of a .txt file , you can simply read the file and store it in a table and extract your desired columns either by column name (y) or by indexing (x) and later save it again as csv via writetable function
trainDataFileName = 'training.csv';
trainData = readtable(trainDataFileName);
y = trainData( : , ["Arch" "CTB" "Direct" "EntireTestName"])
x = trainData(: , 1:5)
writetable(x,'filename.csv')
you can reffer to readtable and writetable from the MATLAB Documentation

Products


Release

R2021b

Community Treasure Hunt

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

Start Hunting!

Translated by