Tested Button Code
(assuming you have three fields, ParseList, OmitList and ResultList - all are multi-value text):
Parse:= @GetField("ParseList");
Omit := @GetField("OmitList");
OmitCount := @Elements(Omit);
ParseCount := @Elements(Parse);
@For( x:=1;
x<=OmitCount;
x:=x+1;
@For(
y:=1;
y<=ParseCount;
y:=y+1;
@If(Parse[y] = Omit[x];
@Do
(
Parse := @If(y = 1;"":@Subset(Parse; y-parsecount); y<parsecount ; @Subset(Parse; y-1):"":@Subset(Parse; y-parsecount);@Subset(Parse; y-1):"");
y := parsecount + 1
);
""
)
)
);
Result := @Trim(Parse);
@SetField("ResultList"; Result)
Hope this helps,
Phil
Return to top
. . RE: Need help with a loop (Phil M Jones 25.Sep.17)
Print this page
