Get_XML_Value function
Description
(Introduced in OpenInsight 4.1.3). Extracts tag values from records that have raw XML data stored in them.
Syntax
Get_XML_Value(Target_Tag, XML_Rec)
Parameters
The Get_XML_Value has the following parameters.
| Parameter | Description | |
|---|---|---|
| Target_Tag | The tag within the XML record from which you wish to extract values. Note: XML tags are case sensitive. However, the Target_Tag argument is not case sensitive. ITEM_DESCRIPTIONS_ENTERED and item_descriptions_entered will both match to the tag, if it exists in the XML file. | |
| XML_Rec | A variable containing the contents of the XML file after it has been read into memory. See the example below. Note: Multivalue fields are also delimited by value marks. |
|
Returns
A value-mark delimited list of values for the records in Target_Tag.
See Also
Example
/*
After the Get_XML_Value() function is called, the variable
item_descriptions will contain the values in the
item_descriptions_entered tag.
*/
declare function Get_XML_Value
filename = 'C:\orders.xml'
OSRead filerec from filename then
item_descriptions = Get_XML_Value( 'item_descriptions_entered', filerec)
end