XMLParser (version 1.7) - Aster Analytics

SELECT * FROM XMLParser (
  ON  input_table 
  Text_Column ('text_column')
  Nodes ('node_pair_string[,...]')
  [ Sibling ('sibling_node_string[,...]') ]
  [ Delimiter ('delimiter') ]
  [ SiblingDelimiter ('sibling_delimiter') ]
  [ MaxItemNum ('max_item_number') ]
  [ Ancestor ('nodes_path' [,...]) ]
  [ OutputColumnNodeID ('output_column_node') ]
  [ OutputColumnParentNodeName ('output_column_parent_node') ]
  [ OutputColumnGrandparentNode_Name
    ('output_column_grandparent_node') ]
  [ ErrorHandler ('{'true'|'yes'|'t'|'y'|'1'|'false'|'no'|'f'|'n'|'0'}
    [;[output_column:]  column[,...]]') ]
  [ Accumulate
    ({ 'accumulate_column' | 'accumulate_column_range' }[,...]')]
);