I have two lists of values
Temp1 - A:B:C:D
Temp2 - 0:0:2:3
in a display field in a view if temp2(x) = 0 take it’s corresponding value out of temp1 so that when I’m finished I end up with
or Temp1 = C:D
Temp2 = 2:3
Just not familiar enough with @Formulas to do this.
Subject: Use @For?
You can use @For to loop through a list and then compare the two lists.
http://www-12.lotus.com/ldd/doc/domino_notes/7.0/help7_designer.nsf/855dc7fcfd5fec9a85256b870069c0ab/22e9e7dab5754f0d8525704a003fe3fe?OpenDocument&Highlight=0,%40For http://www-12.lotus.com/ldd/doc/domino_notes/7.0/help7_designer.nsf/855dc7fcfd5fec9a85256b870069c0ab/22e9e7dab5754f0d8525704a003fe3fe?OpenDocument&Highlight=0,%40For
Howard
Subject: Got it working with @Transform
Got it to work using @Transform
list1 := “A” : “B” : “C” : “D”
List2 := “0” : “0” : “3” : “4”
list := list1 + “~” + list2
@Trim(@Transform(list ; “value” ; @If(@Word(value ; “~” ; 2) = “0”; “”; @Word(value ; “~” ; 2))))
the return is C D
Not sure if the @Transform or the @For would be the most efficient, but got it working.
Thanks Howard