Find row where cell value equals some defined value

2012 3 23
2 个回答
回答已采纳
更新时间：2017 3 21
5 次查看（30 天）

0 个投票

Hi,
I have a list called quarters that looks something like:
1999Q2
1999Q3
1999Q4
2000Q1
I would like to find out which row is for example 1999Q4. So I have defined:
quarter_find='1999Q4'
How could I find the right row? I tried with find function: [row_equal]=strfind(quarters, quarter_find)
I get
[]
[]
1
[]
How could I actually get number of row where those values are equal? (so in this case I would like to ger answer=3)
Could anyone please suggest me something?
Thanks,
Ieva

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

 采纳的回答

Andrei Bobrov
Andrei Bobrov 2012-3-23

3 个投票

eg
data = {'1999Q2'
'1999Q3'
'1999Q4'
'2000Q1'}
out = find(~cellfun('isempty',strfind(data,'Q4')))

3 个评论
显示 1更早的评论 隐藏 1更早的评论

Ieva
Ieva 2012-3-23
Great thank you! It works perfectly! :)
Venkat Ta
Venkat Ta 2017-3-18
编辑：Venkat Ta 2017-3-18
suppose, the data are '10' '10.66' '11' '20' like this, I would like to find out only 10 not 10.66 exactly 1st row only not both the 1 and 2?
And my data is like 90x1 double?
Jan
Jan 2017-3-21
@Venkatesan Thanigaiarasu: Please do not highjack an existing thread. Open a new thread for a new question. Thanks.
'10' '10.66' '11' '20' does not look like a "90 x 1 double". Please clarify this (in the new thread of course).

请先登录，再进行评论。

更多回答（1 个）

Jan
Jan 2012-3-23

0 个投票

The command posted by Andrei is the best Matlab solution I know, but it does not look nice, althozugh this is a standard problem. Therefore I'm using FEX: strncmpr. This function is equivalent to strncmp, but processes the strings from the right. E.g. this helps to filter file names by their extensions.

类别

在 帮助中心 和 File Exchange 中查找有关 Whos 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by