|
Subject:
|
Easy Question - I think
|
|
Posted By:
|
gmoney060
|
Post Date:
|
10/31/2004 1:00:00 PM
|
When you are using the Split() function how do you set the delimiter = to a tabed space? That is how it is in a .txt document, and it is not detecting it if i put " "... any ideas?
|
|
Reply By:
|
Imar
|
Reply Date:
|
10/31/2004 2:22:22 PM
|
Hi there,
Try the constant vbTab that represents a tab character.
Cheers,
Imar
|
|
Reply By:
|
anubhav.kumar
|
Reply Date:
|
11/2/2004 4:03:51 AM
|
Hi ,
Can also try chr(9) .
Anubhav Kumar
|
|
Reply By:
|
mat41
|
Reply Date:
|
11/2/2004 5:54:38 PM
|
This should do it:
someName = Split(someString,vbTab, -1, 1)
Wind is your friend Matt
|