en EN de DE
topbar test
en EN de DE
Search site...
Wie können wir Ihnen helfen?
< Zurück
Drucken

FieldPadFilter

Veröffentlicht18. April 2023
Geändert14. May 2024
VonAlexandra Klettenhofer

Fills values of result columns with characters up to the specified length.

 

AttributeRequiredDescription
TypeNoLeft | Right - Side on which the characters should be added. By default Left.
CharNoCharacter to be used for padding. By default, space character " ".
FieldsYesList of columns to which the filter should be applied.

Attention: must always be specified as a list.
LengthYesThe length to be filled up to

 

Example

In this example, a ClientQuery generates 3 result rows, on which the filter inserts leading zeros until the value is 3 characters long.

--- !ClientQuery
Id: ThreeAgents
Statement: Select 7 as Agent
     UNION Select 123 as Agent
     UNION Select 'Smith' as Agent
ResultFilters:
- FieldPadFilter:
    Length: 3
    Char: 0
    Fields: [Agent]

Result:

Agent
007
123
Smith

Tags:
Inhaltsverzeichnis