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

7 Ansichten (letzte 30 Tage)
Al
Al am 15 Apr. 2015
Beantwortet: Image Analyst am 16 Apr. 2015
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 Kommentare
per isakson
per isakson am 15 Apr. 2015
"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 am 15 Apr. 2015
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.

Melden Sie sich an, um zu kommentieren.

Antworten (1)

Image Analyst
Image Analyst am 16 Apr. 2015
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.

Kategorien

Mehr zu Cell Arrays 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!

Translated by