select row in excel

Hi, I have this data in excel

B B C A B B A B A A B B A B B A A C B B A A B B A B B A B A A B

and I have problem in extracting the rows. This is because the char (A, B, C) are in random rows. So how do I pick char (A), (B) and (C) in random rows?

Thank you.

Answer 1

[Hikaru]

I would use the code below to read the data into MATLAB.

[~,~, raw]  = xlsread('filename.xlsx')

raw will be a cell array containing 'A', 'B', 'C' and [NaN]

I can't help more than this without the specifics. Are the letters stored in the same number of columns? If so, you could convert the letters into char string by

char(raw(i,:)) % i is the rows containing the letters

Note, char() won't work if the element contains NaN.

[mira]

Actually I'm using Psychtoolbox and what I'm doing is when spacebar is pressed, it will recognized the char above. however, I do not manage to recognize the char.