Separating a list

Hi!  I use VB5

Suppose I have any of the following variables:
mail = "bob@soandso.com; yes@yes.com; whatever@whatever.com;blah@blah.com;"

mail = "bob@soandso.com; yes@yes.com; whatever@whatever.com;blah@blah.com"

mail = "whatever@whatever.com"

Or any of the sort.

I'd like to put each (and only) email address, and stick each one into a listbox.
list1.additem (separateemailaddress)

Thanks
jknickelbeinAsked:
Who is Participating?
 
jgvConnect With a Mentor Commented:
Try this:

Private Sub Command1_Click()

Dim mail As String
Dim x As Integer
Dim cnt As Integer
Dim startpos As Integer

mail = "bob@soandso.com; yes@yes.com; whatever@whatever.com;blah@blah.com"
If Right(mail, 1) <> ";" Then mail = mail + ";"

startpos = 1

For x = 1 To Len(mail)
  cnt = cnt + 1
    If Mid(mail, x, 1) = ";" Then
        List1.AddItem Trim(Mid(mail, startpos, cnt - 1))
        startpos = x + 1
        cnt = 0
    End If
Next

End Sub
0
 
spardogCommented:
If you have them seperated with semi colins than try this:

Dim i As Long, addresstemp As String, mail As String
mail = "bob@soandso.com; yes@yes.com; whatever@whatever.com;blah@blah.com;"
i = 1
again:
addresstemp = ""
While Mid$(mail, i, 1) <> ";"
addresstemp = addresstemp + Mid$(mail, i, 1)
i = i + 1
Wend
List1.AddItem (Trim(addresstemp))
i = i + 1
If i < Len(mail) Then GoTo again
0
 
jknickelbeinAuthor Commented:
Thanks guys - works great!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.