Find the cell which is containing a string

hi guys, i have the below array:

A={'Dimension','Weight','Qty','Thk','Total Price'};

now I want to find out which cell (Row and Col number) has the string 'Price' in it, and the answer is row=1, col=5.

i dont know how to find that cell when i have only a part of the whole string in a cell,

please help me what to do, thnx a lot

Answer 1

[Stephan]

A={'Dimension','Weight','Qty','Thk','Total Price'};
[r,c] = find(contains(A,'Price'))

[abb Shp]

thanks Stephan, works well, I appreciate

Answer 2

[Ameer Hamza]

Another solution using regexpi() which takes care of the letter-case too.

[r, c] = find(~cellfun(@isempty, regexpi(A, 'price')))

[abb Shp]

Thanks Ameer, this works too, but letter-case is not important to me in this case, thnx anyway.

[Ameer Hamza]

Yes, I meant that it works for all cases, wether you use 'price', 'Price', 'pRiCe'. regexpi() does not care about the case.

[abb Shp]

Thanks :)

Answer 3

[Setsuna Yuuki.]

A={'Dimension','Weight','Qty','Thk','Total Price'};
b = strfind(A,'Price')

for n=1:length(b)
    if (~isnan(b{n}))
        break;
    end
end

 fprintf("row 1, column %i \n",n)

More info: https://es.mathworks.com/help/matlab/ref/strfind.html

[abb Shp]

thnx Bastian, this works too but wants a more general code