Split function delimiter question

Does the Split function work with more than a 1 character delimiter?

For example..........can you use Split to split this string into an array of strings using xz as the delimiter

abcdxzefgxzhijkxzlmn etc

Quote:

---

Originally posted by ae_jester
Does the Split function work with more than a 1 character delimiter?

For example..........can you use Split to split this string into an array of strings using xz as the delimiter

abcdxzefgxzhijkxzlmn etc

---

no, one at a time

jesus4u -

Get a big text file and try this

Code:

---

Dim a() as string
Dim tmp as string
open "mybigfile.txt" for input as #1
tmp = input(lof(1),1)
a = Split(tmp, vbCrLf)

---

vbCrLf is a two character constant.
:D

So does that mean it works? or is vbCrLf the one exception?