Text Separation

[Lynn]

Hi, I need to retrieve a string from a database which is comprised of several information. An example is 'USA/FRA/GER'. Now, I need to break these info into 'USA', 'FRA' and 'GER' respectively. How do I identify these info and separate them?
Thanks

Rgds
Lynn

[Chris Eastwood]

If you're using VB6, you can use the 'Split' function :


Dim s as string
Dim sArray() as string
Dim l as Long

s = "USA/FRA/GER"

sArray = Split(s, "/")

for l = LBound(sArray) to UBound(sArray)
MsgBox sArray(l)
next




That 'chops' up the delimeted string into an array for you.


Chris Eastwood

CodeGuru - the website for developers
http://codeguru.developer.com/vb

[Lynn]

Thanks Chris!

Lynn