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.

ParameterDescription
Target_TagThe 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_RecA 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

XML_Importer(), Extract_XML_Schema_Name(), Inet_OI_XML(), Create_XML_XSD_Schema()

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
  • No labels