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
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
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"))