I started with help from this support topic:
But I need some help matching a partial string.
In my example:
Students have a set of “awarded units”, which is a lookup field with multiple values.
Those values are matched on a second table to return the “current equivalent” unit, this result is returned in a string.
I then want a set of fields, each dedicated to single unit, to test whether or not that unit exists in the “current equivalent” string. I’ve tried FIND( ) and SEARCH( ) without success (screenshot attached).
Is there a wild card character to help find a value inside a string?
OR can you think of another way for me to tackle this??