Remove the header from multiple text files

Question

Majid Mohamod 2017-5-18

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/340876-remove-the-header-from-multiple-text-files

评论： Star Strider 2017-5-18

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 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Star Strider 2017-5-18

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/340876-remove-the-header-from-multiple-text-files#answer_267517

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 个评论
显示无隐藏无

Majid Mohamod 2017-5-18

Please, Could you explain more in this regard. I still beginner in Matlab!

Star Strider 2017-5-18

在 MATLAB Online 中打开

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.

请先登录，再进行评论。