When you are configuring a .CSV parser, you can enable advanced mapping, where one source field can correspond to multiple source fields or string constants.
About advanced mapping
When using advanced mapping, you can input expressions to map destination fields.
In this mode, each destination field you want to map must be added manually by clicking
Add (
).
An expression is built as a text string, using tokens in it to reference column names or indexes. A text string allows multiple references or string constants to be used, and then the string values are all linked together.
| Token | Definition | Example |
|---|---|---|
| ['SOURCE_FIELD_NAME'] | Insert the value of the source field by name. Applicable to .CSV files with headers. | ['TRANSACTION_ID'] → insert value of column TRANSACTION_ID |
| ['COLUMN_INDEX'] | Insert the value of the source field by index. Applicable to .CSV files with headers. | ['1'] → insert value of column 1 |
| CST_VALUE | Insert a constant string value in the result. | Item ['…'] |
| METHOD(…) | Apply a predefined method using one or multiple arguments. The returned value is always a constant value. | UPPER(Item ['…']) |
| Name | Definition | Entry |
|---|---|---|
| Upper(Expression) |
Returns a copy of the parsed expression into uppercase. Expression can be composed of multiple tokens. |
Upper(Item ['TRANSACTION_ID']) → ITEM TX_ID8 where TRANSACTION_ID value is tx_id8 |
| TimeSpanFromSeconds(double) | Convert seconds as double into timespan. | TimeSpanFromSeconds(2.5) |
| AddTimeSpan(datetime, timespan) | Add timespan to the datetime. |
AddTimeSpan("2020-01-31 07:00:00", 3601) → 2020-01-31 08:00:01 |
Conversions
When parsing fields, a conversion can be realized for datetime types. These conversions are generic and are applied to all datetime destination fields.
| Field | Definition | Default/Example |
|---|---|---|
| Date time format | Format string when converting between dates without time zone offset and strings, for example "yyyy-MM-dd HH:mm:ss.fff". | By default, datetimes are parsed using formats allowed by the parser culture. |
| Date time in UTC | Enable if datetimes are in UTC. If not, datetimes are considered in the parser time zone. |