Operation with field's

108 Views Asked by At

I have field1="ab" "cd" "fg" and field2="ab" "cd" how i can get field3="fg" , distance between the "ab" "cd" ... a new line

1

There are 1 best solutions below

0
On

The difference of two text lists you can get with @Replace:

field3 := @Trim(@Replace(field1; field2; ""));

@Replace replaces all entries in field1 which are also in field2 by an empty string "". The resulting list for your example would have the entries "" "" "fg".

@Trim deletes all empty strings from the list. The final result is then "fg".

Make sure that form's field3 has the properties "Allow multiple values" and "Multi-Value Options" New Line.