By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
This example will extract the data between the <EMPFIRSTNAME> and
</EMPFIRSTNAME> XMLTags from the Bodytext string field that contains the full
Aa very simple solution using a general purpose base function.
In your main code add the following
XMLTag = "EMPFIRSTNAME"
FirstName = GetXMLValue( BodyText , XMLtag )
Function GetXMLValue( SourceXML As String , XMLTag As String )
GetXMLValue = LSMiddle (SourceXML, "<" + XMLTag + ">" , "</" + XMLTag +
Function LSMiddle (st_fullString As String, st_startString As String,
st_endString As String) As String
'-This function was one of the LS String Manipulation functions previously
posted that '-performs the same function as the @Middle
Dim i_startPosition As Integer
Dim i_startLen As Integer
Dim i_endPosition As Integer
i_startPosition = Instr (st_fullString, st_startString)
i_startLen = Len ( st_startString )
If i_startPosition > 0 And st_startString <> "" Then
i_endPosition = Instr (Right$ ( st_fullString, Len ( st_fullString ) -
i_startPosition ) , st_endString )
If i_endPosition > 0 Then
LSMiddle = Mid$ ( st_fullString , i_startPosition + i_startLen , _
Instr ( i_startPosition + i_startLen, st_fullString, st_endString) - (
i_startPosition + i_startLen ) )
LSMiddle = Mid$ (st_fullString, Instr( st_fullString, st_startString) + Len
(st_startString) , Len (st_fullString))
LSMiddle = ""