Split tab delimited flat file in script component
I am using a script component as a source to read from a flat file which is tab delimited..Can anyone tell me how to split the row into columns in vb.. e.g. Dim columnArray As String() = line.Split(Convert.ToChar(" ")) This code is not working as I am getting an error that the splitting string should be exactly one character long.. Thanks in advance
July 10th, 2012 9:13pm

Can anyone help me out here..
Free Windows Admin Tool Kit Click here and download it now
July 10th, 2012 9:36pm

try Dim columnArray As String() = line.Split(vbTab) Rgds Geoff ---------------------------------------------------------- Mark as Answer if this resolves your problem or "Vote as Helpful" if you find it helpful.
July 10th, 2012 9:49pm

Thank you for the heads up.. This worked.. Dim columnArray As String() = line.Split(CChar(vbTab))
Free Windows Admin Tool Kit Click here and download it now
July 10th, 2012 10:02pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics