how to find columnnumber of a specific headername?

11 views (last 30 days)
I have a dataset 69x821. I used this code:
[num, txt, raw] = xlsread('data_copy');
In txt are all the headers for the variables. I want to find the columnnumber for the header 'TRIG'. I looked manually and it is on columnnumber 814. How can I let Matlab find me this number?

Answers (1)

Walter Roberson
Walter Roberson on 9 Nov 2015
[tf, idx] = ismember('TRIG', txt(1,:));
If it is found then tf will be true and txt{1,idx} will be the 'TRIG' that is looked for

Tags

Community Treasure Hunt

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

Start Hunting!