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

3 ビュー (過去 30 日間)
Al
Al 2015 年 4 月 15 日
回答済み: Image Analyst 2015 年 4 月 16 日
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 件のコメント
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 日
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.

カテゴリ

Help Center および File ExchangeCell Arrays についてさらに検索

Community Treasure Hunt

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

Start Hunting!

Translated by