Does the split function allow for multicharacter delimiters?
According to [link ms-help://MS.VSCC.v90/MS.msdnexpress.v90.en/dv_vbalr/html/7e33b047-48fc-493b-bb8d-7d1ac3f90038.htm]Ms-help[/help]:
But some examples shown on the same page seem to imply that a string of characters can be used:
I'm particularly interested in using split(string,vbCrLf) to split an input file in its variuous line constituents, but I do get some strange results. So, I wonder if vbCrLf can be used as a delimiter?
(also sorry for the link: does not seem to work as expected)
_________________________________
In theory, there is no difference between theory and practice. In practice, there is. [attributed to Yogi Berra]
According to [link ms-help://MS.VSCC.v90/MS.msdnexpress.v90.en/dv_vbalr/html/7e33b047-48fc-493b-bb8d-7d1ac3f90038.htm]Ms-help[/help]:
only a one character length string can be used.Delimiter
Optional. Any single character used to identify substring limits. If Delimiter is omitted, the space character (" ") is assumed to be the delimiter.
But some examples shown on the same page seem to imply that a string of characters can be used:
Code:
Split("Alice and Bob", " AND ") results in {"Alice and Bob"}
Split("Alice and Bob", " AND ", ,CompareMethod.Text) results in {"Alice", "Bob"}
I'm particularly interested in using split(string,vbCrLf) to split an input file in its variuous line constituents, but I do get some strange results. So, I wonder if vbCrLf can be used as a delimiter?
(also sorry for the link: does not seem to work as expected)
_________________________________
In theory, there is no difference between theory and practice. In practice, there is. [attributed to Yogi Berra]