awk

The awk compute allows to process the table through an awk script. The script to execute can be put in a separate file for more readability and be called in the script value.

Eg: yaml script: ${file::my-script.awk} for a script named my-script.awk placed in the directory of your connector.

keep and exclude can be used to trim your result values with regular expressions.

separators and selectColumns can be used to separate your result value into multiple columns and keep only those of your choice.

connector:
  # ...
pre: # <object>
  <sourceKey>: # <source-object>

monitors:
  <monitorType>: # <object>
    <job>: # <object>
      sources: # <object>
        <sourceKey>: # <source-object>
          computes: # <compute-object-array>
          - type: awk
            script: # <string>
            exclude:  # <string>
            keep: # <string>
            separators: # <string>
            selectColumns: # <string> | comma separated values

          - type: awk
            script: "${file::embeddedFile-1}"
            keep: ^MSHW;
            separators: ;
            selectColumns: "2,3,4,5,6,7,8,9,10,11,12"