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
CombinedList := Fruit + Status; Temp := @ReplaceSubstring (CombinedList;SoldOut;"0") @Trim(@Left(Temp;"0"))
This was first published in April 2003