How to make variable names the same as the column headers when importing?

Al
2015 4 15
1 个回答
更新时间：2015 4 16
14 次查看（30 天）

0 个投票

Notes:
My column headings are V(001), I(B54)... There are thousands of them.
Currently if I use the import wizard, the column headers do not get used for the variable names. Matlab assigns VarName1, VarName2,...
I am importing a text file.

4 个评论
显示 2更早的评论 隐藏 2更早的评论

per isakson
per isakson 2015-4-15
V(001) and I(B54) are not legal variable names. See isvarname
Al
Al 2015-4-15
Thank you!. Is there a way to have Matlab remove the parenthesis? so I woud have V001, IB54 ect. or is that too difficult?
When I export the data prior to import to Matlab, I must select each item individually or all together. It is much easier to just export every column of data since there are ~3400 of them.
This is what I was trying to do but not sure where to start to remove parenthesis.
http://www.mathworks.com/matlabcentral/answers/203724-subscript-indices-must-either-be-real-positive-integers-or-logicals
per isakson
per isakson 2015-4-15
"Is there a way to have Matlab remove the parenthesis?"
  • With importdata &nbsp AFAIK: No!
  • With textscan &nbsp Yes, but it takes a some lines of code.
Questions
  • Do you really want 3400 separate variables?
  • Do you know the types of the data in each column - string or numerical?
Al
Al 2015-4-15
I will not use all of the 3400 variables. The issue is the 100-200 I would use need to manually selected from a list during export. This would take a long time because they are difficult to find and you need to hold down the control key for each. Its easier just to export all 3400 and let matlab turn them all into variables, then comment out the ones I don't need.
All data are numbers.

请先登录，再进行评论。

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

回答（1 个）

Image Analyst
Image Analyst 2015-4-16

1 个投票

I think the best approach is to use readtable() so that your fields have the names of your column headers. I think it will throw out the parentheses though.

类别

在 帮助中心 和 File Exchange 中查找有关 Text Files 的更多信息

标签

提问:

Al
Al
2015-4-15

回答：

Image Analyst
Image Analyst
2015-4-16

Community Treasure Hunt

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

Start Hunting!

Translated by