Hi Michael,
Sorry for not replying before. I managed to find a way to do this myself, and forgot about my post.
Your method seems to do it, but for reference, here is how I did it:
First, get all data from the selected field into a variable:
Set(ExpFavDataVar,ThisItem.SettingsData);
Then, split the variable's data into other variables:
Set(CodeVar, LookUp(Search(Split(ExpFavDataVar, ","),"Code:","Result"),1=1,Result));
Set(CodeVar, Right(CodeVar,Len(CodeVar)-Find(":",CodeVar)));which sets CodeVar variable to "765".
and repeat the same for all other values within the field, such as:
Set(AmountVar, LookUp(Search(Split(ExpFavDataVar, ","),"Amount:","Result"),1=1,Result));
Set(AmountVar, Right(AmountVar,Len(AmountVar)-Find(":",AmountVar)));which sets AmountVar variable to "876".
