<step id='assigner' className='cz.adastra.cif.tasks.expressions.ColumnAssigner'>
    <properties>
        <assignments>
            <assignment column='text' expression='"Hello, world"'>
                    <scorer explanationColumn="expl" scoreColumn="score">
                    <scoringEntries>
                        <scoringEntry explain="true" explainAs="HELLO_WORLD" key="CA_CHANGED" score="300"/>
                    </scoringEntries>
                </scorer>
            </assignment>
            <assignment column='output' >
                <expression>
                    case (
                        id is null, input + "bbb",
                        id = 1, substr(input, length(input) / 2),
                        id = 2, replace(input, "a", "b"),
                        id = 3, upper(input),
                        id = 4, capitalize(input),
                        id = 5, replicate('0', 5 - length(input)) + input,
                        id = 8, nvl(input, "(null)"),
                        id = 9, toString(toDate('5.4.1980','d.M.yyyy'),'yyyy-MM-dd HH:mm:ss'),
                        "default value"
                    )
                </expression>
                <!--
                    id = 6, indexOf(input,'a'),
                    id = 7, indexOf(input,'a',indexOf(input,'b') + 1),
                -->
            </assignment>
            <!-- when gender is null set it to X -->
            <assignment column='gender' >
                <expression>
                    case (
                        gender is null, "X",
                        gender
                    )
                </expression>
                <scorer explanationColumn="scoring_explanation">
                    <scoringEntries>
                        <scoringEntry explain="true" explainAs="NULL_ORIG_GENDER" key="CA_CHANGED" score="300"/>
                    </scoringEntries>
                </scorer>
            </assignment>
        </assignments>
    </properties>
</step>