How to count the length of a raw?

I have a matrix as follow and would like to read a value from raw(x,2) and perform a length count follow by updating such length count value to (x,3) respectively. x refers to the row.

file={'No','Question','Length';'1','how are you?','';'2','What is your name?','';'3','Where do you stay?','';'4','How old are you?',''}. I tried many ways but the returned length count for all texts is always 1. Won't the length should be based on the actual length of the text e.g. Text='how are you?'; The returned length count should be 12 rather than 1..right?

[Andrei Bobrov]

repeat the question

Answer 1

[KSSV]

Yes length of the text shall change. But you have named the strings in file in the form of cell. You can access the text using f{i,j}.

file={'No','Question','Length';'1','how are you?','';'2','What is your name?','';'3','Where do you stay?','';'4','How old are you?',''} ;
[m,n] = size(file) ;
L = zeros(m,n) ;
for i = 1:m
    for j = 1:n
        L(i,j) = length(file{i,j})
    end
end

[Guillaume]

Or in one line (which will work with any shape of cell array, to boot):

L = cellfun(@numel, file)

[KenL]

I am new to MATLAB. How can I perform the length count if I am reading the file from excel format as following coding.

file='Question.xlsx'; [num,txt,raw]=xlsread(file);

I have tried your suggested coding as well as modifying the coding but it still didn't seem to be working fine when running. Pls advise. Tq.

[KSSV]

[num,txt,raw]=xlsread(file);

num - gives only numbers txt - gives headers if any raw - gives data in the form of cells.

To waht you have applied the above code? You shall apply to raw.

[KenL]

I managed to solve the problem. Thanks Dr.

Answer 2

[michio]

Not sure if I understand your issues correctly, but do you happen to use ()? To see the length of the text inside of the cell, you need to use a curly bracket instead {}.

file={'No','Question','Length';'1','how are you?','';'2','What is your name?','';'3','Where do you stay?','';'4','How old are you?',''};
size(file{1,2})

See Access Data in a Cell Array.

[Guillaume]

numel would be better than size for a vector. size always return a vector of at least 2 elements.