how can i get the a column from a table by it's name

Hello,

i'm new in matlab and i have a problem while importing data.

i need to get a specific column, it's name is the first two character of my filename, the problem is when i search a column that have a char name it works, but when the name of the column is a number it doesn't

exemple from my code :

T = readtable(A,data, 'ReadVariableNames', true);
accel= T.Acceleration ;

the column name is acceleration

it works for the pervious code

but it doen't work when the column name is a number

exemple :

acc= T.6 ;

thanks in advance

sorry for my english i'm tryng my best

Answer 1

[Walter Roberson]

acc = T.('6');

or

acc = T{:,'6'};

[rimbak]

Thank you so much , it works!!

Answer 2

[Image Analyst]

If you know the column number of the column with fieldname "6" you can access it like an array

acc = T(:, 42);

or (if it's not column 42) whatever column "6" is in.

[rimbak]

hello, thanks for your answer.

6 is not the column number but the column name (title)

[rimbak]

6 wouldn't be a fix title it will change depending on the first two numbers of my filename ..

[Image Analyst]

I understand. Did you see that I did not refer to column 6? I referred to column 42 and told you to use the actual column number that you know to hold the one with header "6".

Attach your table in a .mat file.

Don't you know the actual color number where the "6" column appears? Let's say that when you print out the table to the command window you see "6" atop column 4. Then you'd just do

acc = T(:, 4);