You are trying to parse the value into 3 pieces in a query? Use an argument for the function to know which piece to return. Try:
Code:
Function ParseString(sString As String, ColID As String) As String
Dim element As Variant
element = Split(sString, ",")
Select Case ColID
Case "B"
ParseString = Mid(element(1),InStr(element(1),"=")+1)
Case "C"
ParseString = Mid(element(2),InStr(element(2),"=")+1)
Case "D"
ParseString = Mid(element(3),InStr(element(3),"=")+1)
End Select
End Function
Then call the function:
ParseString(input, "B")
ParseString(input, "C")
ParseString(input, "D")
OR
Code:
Function ParseString(sString As String, ColID As Integer) As String
Dim element As Variant
element = Split(sString, ",")
ParseString = Mid(element(ColID),InStr(element(ColID),"=")+1)
End Function
Then the function calls would be:
ParseString(input, 0)
ParseString(input, 1)
ParseString(input, 2)