Looking for Function which is similar to Search and find with multiple search text

Question

Hi All, 
 
 I am Looking for the function or query to check the array value with multiple values similar to search/find function with one search text. 
 
 Validation that I am working on is like I have to check the values "A" and "B" in the string {"A", "C", "C", "B", "A", "C"} and the results should be {1 0 0 1 1 0}. 
 Is it possible to have the function or should we have to create any query rules? 
 
 Thanks......! 
 Vaithyanathan R

alex.ladue · Accepted Answer

Not sure I fully understand what you are asking for here, but maybe one of these helps: a!localVariables(
 local!fullListOfUsers: {"Fred", "George", "Bob", "Cal", "Abe"},
 local!desiredUsers: {"Abe", "Bob"},
 {
 remainingUsers: difference(local!fullListOfUsers, local!desiredUsers),
 indecesOfDesiredUsersBoolean: a!forEach(
 items: local!fullListOfUsers,
 expression: contains(local!desiredUsers, fv!item)
 ),
 indecesOfDesiredUsersInteger: tointeger(
 a!forEach(
 items: local!fullListOfUsers,
 expression: contains(local!desiredUsers, fv!item)
 )
 )
 }
) 
 Results in:

Looking for Function which is similar to Search and find with multiple search text

Top Replies