XML Data

[bobfarr]

Any plans to incorporate XML parsing functionality into Strata (or is there anything already in the product that I'm missing)? In addition to working with flat-files (positional and delimited), we work extensively with XML data (some VERY large XML datasets). It would be great to have the abilty to easily mash XML datasets with flat-files (tables).
.

[Ben]

While there isn't an XML mapper built into the interface itself, the scripting language has a pretty comprehensive XML parser that probably would be able to achieve what you want with a little coding.

For example, to parse an xml file, examine the following minimal example. This can, of course, be combined with file reading routines as well as web request routines to open local or remote xml files.

Code: Select all

var xml = "<?xml version='1.0'?><node>contents</node>";

var node = new XmlNode;
if (node.parse(xml))
{
    // parse succeeded -- print out the contents of the root node
    print(node.getNodeValue());
}