I have a visual basic variable that is holding comma deliminated
information.  What is the easiest way to seperate this information out
into seperate text boxes?  I always have 3 commas in my variable.

Example: MyString = 1,Doe,John,477-76-2222 

text1.text = 1
text2.text = Doe
text3.text = John
text4.text = 477-76-2222

[Note: the information between the commas changes line to line.]

---

Clarification of Question by pmclinn-ga on 31 Oct 2002 21:27 PST

Note:  The information changes in "MyString" because I'm importing
information in from a text file and then writing it to a database.

Hi, 


The VB Split and Join functions support only one delimiter, and since
you are always using a comma for you delimination, there should be no
problems with using that command.

This article will show you exactly how to do that.

VB CodeGuru
http://www.codeguru.com/vb/articles/2119.shtml

Query

+"VB" +Split +Function

thanks, 

webadept-ga

Your answer works and I did not have to add in module overhead.  Thank
you!  This solution is fast and efficient!  The only thing missing,
that would of given you a 5 star rating, was how the "output" would
look.

Hi,
I have a very  simple way to solve the problem.Try this code in the
event handler u want to execute your task. I have user text control
array for display.I think that should not be problem

Dim mystring As String
mystring = "1,vamsi,krishna,7248038"
temp = mystring
i = 0
Do
If InStr(1, temp, ",") <> 0 Then
a = Mid(temp, 1, InStr(1, temp, ",") - 1)
Text1(i) = a
temp = Mid(temp, InStr(1, temp, ",") + 1)
Else
a = temp
Text1(i) = a
Exit Do
End If
i = i + 1
Loop Until Len(temp) = 0


Hope your problem will be solved
regards
Vamsi Krishna
India