When using RemoveEmptyEntries finding a separated repeated will fail.
Const Sentence As String = " word word"
Dim Words() As String
Dim Word As Variant
Words = CorString.Split(Sentence, " ", Options:=RemoveEmptyEntries)
For Each Word In Words
Debug.Print CorString.Format("'{0}'", Word)
Next
This should produce the following array ("word", "word"). Instead, it returns ("","word word").
When using
RemoveEmptyEntries
finding a separated repeated will fail.This should produce the following array
("word", "word")
. Instead, it returns("","word word")
.