how to find columnnumber of a specific headername?

2 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

Categories

Find more on Arduino Hardware in Help Center and File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!