PDA

Click to See Complete Forum and Search --> : Storing Info separated by (,) in a database


Smie
Jan 8th, 2000, 05:41 AM
If I store info like:

Hello , My , Name , Is , Smie

That in a database, and bring it back, how would I be able to separate that info, and place each individual word, in a listbox? Thanx

Jan 8th, 2000, 06:10 AM
assuming that each word is delimited by a comma you could use Split()

Dim arySingleWordsArray

arySingleWordsArray = Split("Hi,My,Name,Is, Smie",",")

after that line, arySingleWordsArray would contain a zero-based single dimension array of each word separated by a comma.
arySingleWordsArray(0) = "Hi"
arySingleWordsArray(1) = "My"
arySingleWordsArray(2) = "Name"
arySingleWordsArray(3) = "Is"
arySingleWordsArray(4) = "Smie"

...from here you can spin through and add each one to a list box.