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)
Show older comments
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
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')
Answers (1)
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')
0 Comments
See Also
Categories
Find more on Text Analytics Toolbox in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!