This will allow you to retrieve one value out of a combined list of two fields according to another field.
For example I have the following fields:
Field1 : Fruit values : Apple,Grape,Orange,Lemon
Field2 : Status values : InStock,Soldout,Instock,Soldout
Field3 : Soldoutlist;
Field4 : SoldOut
Add the two fields together in a varialble:
CombinedList = AppleInstock,GrapeSoldout,OrangeInstock,LemonSoldout,br>
Replace the value that you are looking for with a "0" in a new variable.
Trim the list and get the new list of the fruit that is soldout.
SoldoutList = Grape,Lemon
Code
CombinedList :=
Fruit + Status;
Temp := @ReplaceSubstring
(CombinedList;SoldOut;"0")
@Trim(@Left(Temp;"0"))
