hiya
i have a field like tis and it contains
field a
bob, cat, dog, jam, elephant, and more
For example if I want to select bob
i can do IF(WILDMATCH(FIELD A),*bob*>0,1,0) will give me 1 and 0
i want it to return bob I can do IF(IF(WILDMATCH(FIELD A),*bob*>0,1,0)=1,bob,’’)
but if I want to return multiple word how can I do this?
Or easier can I do something like from field a if = *bob* return bob