Netsuite : Saved search that extracts data for a list

In case where you have a list(comma delimited) and needs to extract data from Netsuite then this search can be used
Create a New search and in criteria choose Formula Numeric and then enter condition
– CASE WHEN (INSTR(‘list‘, {field} )<>0) THEN 1 ELSE 0 END
– Formula(Numeric) = equal to
– Value = 1

List : comma delimited list that needs to be extracted
field : The netsuite field the list value belongs to
EX : CASE WHEN (INSTR(‘david.nicholson@2ergo.com 2davidbrent@gmail.com’, {email} )<>0) THEN 1 ELSE 0 END