Login | Register   
RSS Feed
Download our iPhone app
Browse DevX
Sign up for e-mail newsletters from DevX

By submitting your information, you agree that devx.com may send you DevX offers via email, phone and text message, as well as email offers about other products and services that DevX believes may be of interest to you. DevX will process your information in accordance with the Quinstreet Privacy Policy.

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