How to count the length of a raw?

2 次查看（过去 30 天）
KenL
KenL 2016-10-4
评论： KenL 2016-10-5
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?

请先登录，再回答此问题。

采纳的回答

KSSV
KSSV 2016-10-4
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
  4 个评论
显示 2更早的评论
KSSV
KSSV 2016-10-4
[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
KenL 2016-10-5
I managed to solve the problem. Thanks Dr.

请先登录，再进行评论。

更多回答（1 个）

michio
michio 2016-10-4
编辑：michio 2016-10-4
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.
  1 个评论
Guillaume
Guillaume 2016-10-4
numel would be better than size for a vector. size always return a vector of at least 2 elements.

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by