spilt data

[Guest]

In my table i have data such as cars-- trucks - etc,
how can i remove the - from the data item?

 

[Roger Bavaud]

I dont know if I understand what's your question.

This sample shows how you can craete a data array from a delimitted string.
Dim y As String = "Test1-Test2-Test2"
Dim x As Array() = y.Split("-")