Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

what function to Parse a column with comma separted values

Status
Not open for further replies.

fr2

Programmer
May 13, 2008
45
US
i have a TableA column .... with a comma separating different items ...

what function can I use to Parse this column to get each item into an array type object ... like a hashtable or arraylist

TableA

Column
------
first item, second item, third item, fourth item

dim myhash as new Hashtable

myhash.Add( 1, first item)
myhash.Add( 2, second item)
myhash.Add( 3, third item)
myhash.Add( 4, fourth item)

I want to grab each item .. and check later what value it contains ..
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top