Check if the value is in the list of numbers

Question

Let's say I have a group of numbers 23,56,128,567, and I need to apply conditional logic in which, if a variable myDataexists in the group of numbers above, then I continue, otherwise I do not.

Sorry, you need to learn some outdated codes and do not know exactly how to do this in VBScript.

Answer 1

You can put the values ​​in Dictionary:

Set list = CreateObject("Scripting.Dictionary")
list.Add  23, True
list.Add  56, True
list.Add 128, True
list.Add 567, True

and then check if your value exists in the dictionary:

If list.Exists(myData) Then
  'do stuff
End If

And there ArrayListwill be another option:

Set list = CreateObject("System.Collections.ArrayList")
list.Add 23
list.Add 56
list.Add 128
list.Add 567

If list.Contains(myData) Then
  'do stuff
End If

Answer 2

Serenity , , .

:

If instr("|23|56|128|567|","|" & myData & "|") then ...

,

Answer 3

If instr("23,56,128,567", myData) then ...

vbscript, .