Visual Basic Syntax - Re: how to designate TAB as a delimiter in Split() ?

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Re: how to designate TAB as a delimiter in Split() ?

Ken Halter

2005-08-10, 5:08 pm

"steve" <steve@here.com> wrote in message
news:7MqKe.81$2Q.44@tor-nn1.netcom.ca...
> Hello,
> as the subject says, I googled it to no avail.
>
> Do I have to enter a specific code, and what is it?
>
> TIA
> -steve

vbTab or Chr$(9)
'===========
Private Sub Form_Load()
Dim sStr As String
Dim sArray() As String
Dim i As Integer

sStr = "This" & vbTab & "and" & vbTab & "That"
sArray = Split(sStr, vbTab)

For i = 0 To UBound(sArray)
Debug.Print sArray(i)
Next

End Sub
'===========

--
Ken Halter - MS-MVP-VB - http://www.vbsight.com
DLL Hell problems? Try ComGuard - http://www.vbsight.com/ComGuard.htm
Please keep all discussions in the groups..

Sponsored Links