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
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.
vbforums.com
Copyright Internet.com Inc., All Rights Reserved.