Remove the header from multiple text files
2 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Majid Mohamod
el 18 de Mayo de 2017
Comentada: Star Strider
el 18 de Mayo de 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 comentarios
Respuesta aceptada
Star Strider
el 18 de Mayo de 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 comentarios
Star Strider
el 18 de Mayo de 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.
Más respuestas (0)
Ver también
Categorías
Más información sobre Text Files 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!