i used google sheet : i need function in c2

[dabielcrbyton]

i used google sheet :

a1	b	c	d
a2	2S 5D [AC KH 2S QS JS]
a3
a4

please i have this string in b2
2S 5D [AC KH 2S QS JS]
i need function in c2
to do that :
we can see that before the [ ]
are the sign "2"
i need function that determinant if inside the [ ]
their are also the sign 2
and if so i need it to writing in c2
the sign 2

the same thing i need to do with the sign:
A
K
q
J
10
9
8
7
6
5
4
3


and if the function don't find :
i want it to write "no" in c2

 

[jasonb75]

Is this what you want to do?

Book1
	B	C	D
2	2S 5D [AC KH 2S QS JS]	2S	no
Sheet1

Cell Formulas
Range	Formula
C2	C2	=IF(ISNUMBER(SEARCH(LEFT(B2,2),RIGHT(B2,16))),LEFT(B2,2),"no")
D2	D2	=IF(ISNUMBER(SEARCH(MID(B2,4,2),RIGHT(B2,16))),LEFT(B2,2),"no")

 

[dabielcrbyton]

Is this what you want to do?

Book1
	B	C	D
2	2S 5D [AC KH 2S QS JS]	2S	no
Sheet1

Cell Formulas
Range	Formula
C2	C2	=IF(ISNUMBER(SEARCH(LEFT(B2,2),RIGHT(B2,16))),LEFT(B2,2),"no")
D2	D2	=IF(ISNUMBER(SEARCH(MID(B2,4,2),RIGHT(B2,16))),LEFT(B2,2),"no")

thank you very much



but i have a problem
your function give me result of "no" to this
2S KC [AC KH QS 3H JS]

but as you see there is
K before the [ ]
and K inside the [ ]
so the result sould say K




also there is a problem with this :
2S 7C [2C 7H 4C 3H JS]
because there is also 2 and 7 before the [ ]
and 2 and 7 inside the [ ]
so the result should say 2 7

 

[jasonb75]

I had set the formula to match the face value and suit of the card. These versions will do face value only.

=IF(ISNUMBER(SEARCH(MID(B2,2,1),RIGHT(B2,16))),LEFT(B2,2),"no")

=IF(ISNUMBER(SEARCH(MID(B2,5,1),RIGHT(B2,16))),LEFT(B2,2),"no")

 

[dabielcrbyton]

thank you very much



but i have a problem
your function give me result of "no" to this
2S KC [AC KH QS 3H JS]

but as you see there is
K before the [ ]
and K inside the [ ]
so the result sould say K




also there is a problem with this :
2S 7C [2C 7H 4C 3H JS]
because there is also 2 and 7 before the [ ]
and 2 and 7 inside the [ ]
so the result should say 2 7

I had set the formula to match the face value and suit of the card. These versions will do face value only.

=IF(ISNUMBER(SEARCH(MID(B2,2,1),RIGHT(B2,16))),LEFT(B2,2),"no")

=IF(ISNUMBER(SEARCH(MID(B2,5,1),RIGHT(B2,16))),LEFT(B2,2),"no")

yes i need the face value
and not the suit

but i need also the the
J q K A
because this is poker cards


i will publish it again in the:
General Discussion & Other Applications
thank you my friend

 

[RoryA]

i will publish it again in the:
General Discussion & Other Applications

Please don't. We do not allow posting the same question more than once, so I have deleted your duplicate posting.

 

[dabielcrbyton]

i change the question

OK
i follow the rule

 

[dabielcrbyton]

can you help me with this issue i have

 

[jasonb75]

I just realised my error.

=IF(ISNUMBER(SEARCH(LEFT(B2,1),RIGHT(B2,16))),LEFT(B2,2),"no")

=IF(ISNUMBER(SEARCH(MID(B2,4,1),RIGHT(B2,16))),MID(B2,4,2),"no")

 

[dabielcrbyton]

a1	b	c	d
a2	9 K [9 K J 3 J]	9	[

that what it show in c2
9

it should show
9 k


because 9 and k
show before the [ ]
and also inside the [ ]



as i say my friend
i using google sheet