extractstrTR

extractstrTR Transformer

Purpose

The purpose of this transformer is extract a part of a column value (sub string) and update the column accordingly.

Configuration by using the SQL directly in the configuration file

The specific configuration (as a Datasource) in the configuration file section parameters inclues the following parameters:

• column: The Column name
• start: start the substring at this position
• length: extract this length of the column value

Data sources configuration

• Inputs : 1 input
• Outputs : 1 output

Configuration example:

    "transformers":  [
    { 
        "id": "T2",
        "classname": "pipelite.transformers.extractstrTR",
        "inputs" : [ "S1" ],
        "outputs" : [ "S2" ],
        "parameters": {
            "column": "concept:name",
            "start": 2,
            "length": 3
        }   
    }],
    ... ] ...