AnsweredAssumed Answered

Match single ID with a list of IDs in fields

Question asked by sadhu-x on Sep 20, 2018
Latest reply on Sep 21, 2018 by user19752

I have a field with a list of group IDs, in this form: 5261|7046|7051|7056|7061|7066|7606

 

I need to match each of these numbers to a table that has a field with a single number to let me know of a new group number. So, it needs to pick out from these lists that can range from 2 or more numbers.

 

Does anyone have a suggestion of how to do this easily?

Outcomes