Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I've been trying many ideas but no luck and hoping the community can assist.
I am wanting to "look" within a field and when I match a particular string of characters, in this case "IBM", return a "Yes" text string into my table. Something like:
=IF[(Field) Contains string(IBM), Return "Yes"]
I know that's not proper syntax but hoping writing out the logic conveys my goals better.
Any help greatly appreciated! Thanks... Wes
Try this
If(WildMatch(Field, '*IBM*'), 'Yes')
You can also try this
If(Field LIKE '*IBM*', 'Yes')
Thanks Sunny! This is perfect...
Sunny - what if you wanted to return just the substring that had the 'IBM' in it? What would you change the 'YES' too.
If(Field LIKE '*IBM*', 'Yes')
Should be
If([Field] LIKE '*IBM*', [Field])