Browse DevX
Sign up for e-mail newsletters from DevX

Tip of the Day
Language: Visual Basic
Expertise: Intermediate
Apr 12, 2002



Building the Right Environment to Support AI, Machine Learning and Deep Learning

Validate Text Against a List of Values

I often find it necessary to check that a string is valid by ensuring it exists in a list of strings. For instance, you might need to check that a user-entered province/state code exists within a list of valid province/state codes. You can do this quickly without looping through the list each time you need to compare. Suppose you have an array containing all valid province/state codes:
Private ValidCodes() As String

First, translate this array into a string of separated valid codes:
Private ValidList As String
Private Sub CreateValidList()
Dim i As Long, sT As String
For i = LBound(ValidCodes) To _
sT = "|" & ValidCodes(i)
Next i
sT = sT & "|"
ValidList = sT
End Sub

I separate the items in the string with vertical bars ("|") because in this situation, bars don
Andrew Sadavoy
Comment and Contribute






(Maximum characters: 1200). You have 1200 characters left.



Thanks for your registration, follow us on our social networks to keep up-to-date