match string within field

[sat_tok52]

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,

[Prashant_Naik]

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

[sat_tok52]

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,

[Prashant_Naik]

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