Split function delimiter question

[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

[jesus4u]

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

[jim mcnamara]

jesus4u -

Get a big text file and try this

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.

[ae_jester]

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