importdata no recognizing column headers

7 次查看（过去 30 天）
hxh103
hxh103 2014-12-1
编辑： hxh103 2014-12-1
I am using MATLAB 2012a on Windwos 7. I am trying to import a tab separated text file. The problem is that importdata does not recognize columnheaders if the length of the data is different from the length of the columnheaders. The program I am using is outputting an extra header eventhough I have no data for it. I can't change the output and there are about 100 columns. i want to be able to search for a specific column to get the right index to read only the relevant data. Here is a small example of the text file (spaces are tabs). so in this example, there are 4 headers, but only 3 columns of data. Matlab does not recognize the column headers and won't put them into columns.
header1 header2 header2 header4
1 2 3
2 3 2
3 4 5
1 2 3
3 4 5
2 4 5
any solutions out there? I don't want to go into each file to delete the extra columns (it does work but I have hundreds of these outputs). One solution would be to go into the text data and rewrite the columns that way. but I'm hoping there is an easier and faster method out there...

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

采纳的回答

Azzi Abdelmalek
Azzi Abdelmalek 2014-12-1
s=importdata('file.txt')
h=strsplit(s.textdata{:})
data=s.data
n=size(data,2)
out=[h(1:n);num2cell(data)]
  3 个评论
显示 1更早的评论
hxh103
hxh103 2014-12-1
编辑：hxh103 2014-12-1
Sorry, I forgot to mention there are other text above the column headers. so the above code won't work as it doesn't give the correct headers. The following code works for me
s=importdata('file.txt')
t=s.textdata{end,1}; %assumes your header is in the last row
h=regexp(t,'\t','split')
h= 'header1' 'header2' 'header3' 'header4'
Cheers, hope this helps someone else out in similar situation.

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Workspace Variables and MAT Files 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by