Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


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

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 _
UBound(ValidCodes)
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.

 

 

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