Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a field and when I match a particular string of characters, in this case "ONE", return a "Yes" text string into my table. Below logics i have tried it's working, but in that same filed have DONE and NONE Text ,the ''Yes" not return in that row .But as per requirement "Yes' returns only ONE text in the string.
=IF(Field LIKE '*ONE*', 'Yes')
=Pick(WildMatch(Filed '*ONE*',), 'YES')
=If(WildMatch(Field like '*ONE*') ,'YES')
Thanks,
Hi,
If you put *ONE* in the condition it will consider every word that has ONE in it.
So you can do this,
Pick(Wildmatch(Field,'ONE','DONE'),'Yes','Other words')
I think i have understood the question right 😅
Regards,
Prashant
Hi Prashant,
"Yes" should be return only when string having "ONE" ,but what happening here the YES displaying ONE ,DONE ,NONE.
Expected Result:
String = I AM ONE= YES
String =I AM DONE =Here Expecting Results is NULL but YES Displaying here also,i don't want like that YES should display only ONE in the string...
Thanks,
Hi,
you can do this
Pick(Wildmatch(Field,'* ONE *','*DONE*'),'Yes','Other words')
it will consider only * space ONE space * words
Might be this solve your query
Regards,
Prashant