About advanced mapping of a .CSV parser - Transaction Finder 3.2.0.0

Transaction Finder Plugin Guide 3.2.0.0

Applies to
Transaction Finder 3.2.0.0
Last updated
2022-05-05
Content type
Guides > Plugin and extension guides
Language
English
Product
Transaction Finder
Version
3.2

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 to map must be added manually by clicking on the add () button.

An expression is built as a text string, using tokens in it to reference column names or indexes. This allows the use multiple references or string constants, which link all of the string values together.

Advanced mapping
Token Definition Example
['SOURCE_FIELD_NAME'] Insert the value of the source field by name. This applies to .CSV files with headers. ['TRANSACTION_ID'] → insert value of column TRANSACTION_ID
['COLUMN_INDEX'] Insert the value of the source field by index. This applies to .CSV files with headers. ['1'] → insert value of column 1
CST_VALUE Insert constant string value in result. Item ['…']
METHOD(…) Apply a predefined method using one or multiple argument. The returned value is always a constant value. UPPER(Item ['…'])
Methods
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 generics, they will be applied on 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.