Delimited String Functions - Simple

Public Function DelimElement(DelimStr As Variant, ElementIndex As Integer, Optional Delimiter As String = ",") As Variant

Return the nth element (starting at 1) of the delimited string

Public Function DelimElementCount(DelimStr As Variant, Optional Delimiter As String = ",") As Long

Return the number of elements in the delimited string

Public Sub DelimListAdd(ByRef DelimStr As String, AddItem As String, Optional Delimiter As String = ",")

Add an element to the delimited string.


Public Function DelimListAddRtn(ByRef DelimStr As String, AddItem As String, Optional Delimiter As String = ",") As String

Add an element to the delimited string, returning the new delimited string

Public Function DelimListMemberIndex(DelimStr As String, FindItem As String, Optional Delimiter As String = ",") As Integer

Return the index of the element of the delimited string matching the passed string, or -1 if not found

Public Function DelimListQuoteElements(DelimStr As String, Optional Delimiter As String = ",", Optional DoubleQuotes As Boolean = False) As String

Step through each element in the delimited string and trim and quote it, returning the new delimited string

Public Function DelimListRemoveMember(DelimStr As String, RemoveIndex As Integer, Optional Delimiter As String = ",") As String

Remove the element with the specified index from the delimited string.


Public Function DelimListUnquoteElements(DelimStr As String, Optional Delimiter As String = ",") As String

Step through each element in the delimited string and trim and unescape it, returning the new delimited string