Remove the header from multiple text files
2 views (last 30 days)
Show older comments
Majid Mohamod
on 18 May 2017
Commented: Star Strider
on 18 May 2017
Hi all..
I use the following code to export multiple columns in excel file to multiple text files (each column export as text file).
Walter Roberson wrote me the following code:
data = readtable('YourFileName.xls');
varnames = data.Properties.VariableNames;
for col = 1 : size(data, 2)
thisvar = varnames{col};
filename = sprintf('split_%s.txt', thisvar);
writetable( data(:,col), filename );
end
It works very well, but the only problem is each text file gets a header X1. Can I use this script without having header? The following screenshot explain more about the problem:
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/164209/image.png)
0 Comments
Accepted Answer
Star Strider
on 18 May 2017
Consider using xlsread. It will separate the numeric values from the headers. You can still have access to the headers (and other non-numeric data) as well as the raw data by requesting 2 or 3 outputs from xlsread instead of only the first output.
2 Comments
Star Strider
on 18 May 2017
I would do something like this:
[numeric_data, string_data, raw_output] = xlsread('YourFileName.xls');
The ‘numeric_data’ array will have your numeric data (possibly with NaN values in the first row that you can easily eliminate) as a double array. The headers (and other string data) will be in the ‘string_data’ output, and the entire contents of the file (as a cell array) will be in the ‘raw_output’ variable.
See if that does what you want.
More Answers (0)
See Also
Categories
Find more on Text Files 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!