Wie können wir Ihnen helfen?
< Zurück
Drucken

FieldTrimFilter

Removes characters in result columns on the specified side.

 

AttributeRequiredDescription
TypeNoLeft | Right | Both - Side on which the characters should be removed. By default Left.
TrimmedCharNoCharacter to be removed. By default the Null character (not the digit "0 ").
TrimmedFieldsYesList of columns to which the filter should be applied.

Attention: must always be specified as a list.

 

Example

In this example, a ClientQuery generates 2 result rows on which the filter removes leading zeros.

--- !ClientQuery
Id: TwoAgents
Statement: Select '007' as Agent
     UNION Select 123 as Agent
ResultFilters:
- FieldTrimFilter:
    TrimmedChar: 0
    TrimmedFields: [Agent]

Result:

Agent
7
123
Inhaltsverzeichnis