Remove the header from multiple text files
5 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Majid Mohamod
am 18 Mai 2017
Kommentiert: Star Strider
am 18 Mai 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:
0 Kommentare
Akzeptierte Antwort
Star Strider
am 18 Mai 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 Kommentare
Star Strider
am 18 Mai 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.
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Text Files finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!