we have a lot of eternal XML files. we’d like to read them and replace specific node value using Lotus Script. how can i do it? it would be great if you can tell me which notes objects have i to use. (it would be perfect if you give me simple sample code.)
thanks in advance.
Subject: how can i read eternal XML file and convert it?
try this
A simple function to extract the vaue from XML tags
This example will extract the data between the and
XMLTags from the Bodytext string field that contains the full
XML definitions.
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 +
“>” )
End Function
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 ) )
Else
LSMiddle = Mid$ (st_fullString, Instr( st_fullString, st_startString) + Len
(st_startString) , Len (st_fullString))
End If
Else
LSMiddle = “”
End If
End Function
Subject: RE: how can i read eternal XML file and convert it?
thank you so much, Michael.it really help me. thanks.
Subject: RE: how can i read eternal XML file and convert it?
Where the ‘BodyText’ come from?Please elaborate.
Subject: RE: how can i read eternal XML file and convert it?
You’re kidding, right? Bodytext is an argument to the function – it comes from wherever you got it from.
Subject: RE: how can i read eternal XML file and convert it?
Asking about the method. Could it be an object, stream, node, array, string…, file name, url?
How needs the argument to be declared?