NAME¶

stag-flatten - turns stag data into a flat table

SYNOPSIS¶

  stag-flatten -c name -c person/name dept MyFile.xml

DESCRIPTION¶

reads in a file in a stag format, and 'flattens' it to a tab-delimited table format. given this data:

  (company
   (dept
    (name "special-operations")
    (person
     (name "james-bond"))
    (person
     (name "fred"))))

the above command will return a two column table

  special-operations      james-bond
  special-operations      fred

If there are multiple values for the columns within the node, then the cartesian product will be calculated

USAGE¶

  stag-flatten [-p PARSER] [-c COLS] [-c COLS] NODE <file>

ARGUMENTS¶

-p|parser FORMAT

FORMAT is one of xml, sxpr or itext

xml assumed as default

-c|column COL1,COL2,COL3,..

the name of the columns/elements to write out

this can be specified either with multiple -c arguments, or with a comma-seperated (no spaces) list of column (terminal node) names after a single -c

-n|nest

if set, then the output will be a compress repeating values into the same row; each cell in the table will be enclosed by {}, and will contain a comma-delimited set of values

SEE ALSO¶

Data::Stag