String.Split for vb.net

jennietan · Apr 28, 2012

I am trying to parse a tab delimited file into an array. In vb you would use: a = split(s,Chr(9)) where a is an array, s is a tab delimited string, and Chr(9) is the tab. In vb.net it is supposed to be something like this a = s.split(new char [] {'???'}) I have tried numerous modifications of the above with no luck a = s.split(Chr(9)) a = s.split(Char(9)) a = s.split(new Char [] {Chr(9)} etc. Where the ??? is a char. I keep getting a value of type system.char cannot be converted to a 1-dimensional array of system.char What do I need to do to parse the tab delimited file into an array?Use vbTab to indicate the tab character. Here is a simple example that works: 'Each word in s is tab separated. Dim s as String = "This is a test" Dim a() as String a = s.split(vbTab) Dim tmp as String for each tmp in a response.write(tmp & " ") nextI am still having a problem. The error states that vbTab is not declared.(Do I need to import another class?) Below is the code I am using( I have removed some of the code to keep the post to a minimal size: Imports System Imports System.Data Imports System.Data.ADO Imports System.Collections Imports System.IO Imports System.String Namespace WSC Public Class Inventory Public Function PREdoDB(ByVal company As String,ByVal arrySize As Integer) As String ' Dim s as string = "This is a test" PREdoDB = doUpdateLS(s) End Function Private Function doUpdateLS(s As String) As String Dim a() As String a = s.split(vbTab) doUpdateLS = s End Function End Class End Namespace Add: Imports Microsoft.VisualBasic Does that do the trick?I tried adding the 'Imports Microsoft.VisualBasic' The same error occurs stating that vbTab is not defined. We also tried installing visual studio.net on the web server with no luck either. I am runing out of options and are very close to rollng my own split function. If u can think of anymore suggestions it would be greatly appreciated. I figured out what the problem was. Instead of: dim a() as string it should have been: dim a as array Thanks for the help

String.Split for vb.net

jennietan

New Member