Make a Split function that skips quotes that contain the delimiter. Any opening quote will prevent delimeter from splitting the string.
Syntax:VB Code:
Public Function QuoteSplit(ByRef Expression As String, Optional ByRef Delimiter As String = " ", _ Optional ByVal Limit As Long, Optional ByVal Compare As VbCompareMethod = vbBinaryCompare) As String() End Sub
This is a friendly challenge! This means that you can come up with entirely new suggestions, improve code posted earlier on and give suggestions to other participating in to the challenge.
Purpose is free: you can aim for shortness, you can aim for speed, you can aim for balancing code length and speed. Do what you like most
Edit!
You may drop Limit and Compare if you don't want to do them.
Also fixed Delimiter code (default = " ").
Edit #2
And now fixed the Delimiter spelling in the code.





Reply With Quote