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

Go to topic 21596

Return to index page 726
Return to index page 725
Return to index page 724
Return to index page 723
Return to index page 722
Return to index page 721
Return to index page 720
Return to index page 719
Return to index page 718
Return to index page 717