finding number of a column in a cell (column that contains a specified string)

how could it be done for finding first which array of a cell is equal a specified string and in second, what is number of column that contains this string

for example:

CELL={'a','b','c','d','e','f',...}

finding 'a' in CELL?(which row and column)

Answer 1

[Fangjun Jiang]

CELL={'a','b','c';'d','e','f'};
[Row,Col]=ind2sub(size(CELL),find(ismember(CELL,'e')))

or

[Row,Col]=ind2sub(size(CELL),find(strcmp(CELL,'e')))

[Grzegorz Knor]

ind2sub function is unnecessary:

[row col] = find(strcmp(CELL,'a'))

[mohammad]

great! perfect!

speed of this one is so nice for a cell 600*600

[Jan]

Grzegorz Knor's find(strcmp(C, 'a')) is the fastest solution.

[Fangjun Jiang]

@Grzegorz, Good catch!

[mohammad]

Hi Jan,

yes this the fastest that Fangjun told

Answer 2

[Harry MacDowel]

find(char(CELL)=='a')

Does that help?

[mohammad]

thanks but errors:

??? Undefined function or method 'eq' for input arguments of type 'cell'.

[Harry MacDowel]

sorry should be

find(char(CELL)=='a');

[Harry MacDowel]

I corrected the answer up there.

[mohammad]

now this error:

??? Error using ==> eq

Matrix dimensions must agree.

Answer 3

[Grzegorz Knor]

See in documentation:

doc strfind

strfind(CELL,'a')

[mohammad]

thanks a lot

in doc it says for idx=strfind(CELL,'a');

idx{:,:} must give indices

but when in command widow i run it, doesn't give indices

its very important for me to know the string is in which row and column

[Grzegorz Knor]

CELL={'a','b','c','d','e','f';'f','e','d','c','b','a'}

idx = strfind(CELL,'a');

[row col] = find(~cellfun(@isempty,idx))

[mohammad]

thanks

it works good, only slow for a cell 600*600

thanks a lot

[Jan]

I definitely prefer Grzegorz's solution in the comment above:

find(strcmp(C, 'a'))

[mohammad]

Hi Jan

OK let me check