Mike
Here is an example using Multi select fields for the input and output. The result will be a multi select apparance with the unique values.
var text ListOne = ToText([List 1]);
var text ListTwo = ToText([List 2]);
var text A = Trim(Part($ListOne,1,";"));
var text B = Trim(Part($ListOne,2,";"));
var text C = Trim(Part($ListOne,3,";"));
var text D = Trim(Part($ListOne,4,";"));
var text E = Trim(Part($ListOne,5,";"));
Split(List(";",
If(Contains($ListTwo,$A), $A),
If(Contains($ListTwo,$B), $B),
If(Contains($ListTwo,$C), $C),
If(Contains($ListTwo,$D), $D),
If(Contains($ListTwo,$E), $E)))
.........
and here is the count of the # of common terms
var text String = ToText([List 2 in List 1]);
Count(
Trim(Part($String,1, ";"))<>"",
Trim(Part($String,2, ";"))<>"",
Trim(Part($String,3, ";"))<>"",
Trim(Part($String,4, ";"))<>"",
Trim(Part($String,5, ";"))<>"")
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commark.shnier@gmail.com------------------------------
Original Message:
Sent: 09-09-2020 20:15
From: Mike Tamoush
Subject: Check to see if a value in one list, is contained in another list
How would I search through one list and see if any of those values are contained in another list?
Then return it as a formula checkbox, or formula text, the output doesn't matter I can deal with that. Just not how to approach this.
------------------------------
Mike Tamoush
------------------------------