±append

Appends a value to the end of the data field.
The value can be a literal, the contents of another field, or any expression.
For appending a whole new field to the end of the data row, use ±add.
 

Pattern

Usage

-append[FieldName]=1234

Appends "1234" to the column FieldName .

-append[NetPrice],[GrossPrice]= USD

Appends the value " USD"  to both fields NetPrice and GrossPrice.
Please see the whitespace before "USD", this will become part of the resulting field content.
 

-append[NetPrice],[GrossPrice]= [Currency]

Appends a whitespace and then the content of the field Currency  to both fields NetPrice and GrossPrice.
 

Example

[Wrong example, must be changed]
If there is a csv file:

-append["Transport Weight"]={(1,05*["Product Weight"]),3}g

Appends a new column Transport Weight to the line and fills it with the value of the field Product Weight * 1.05. The output shall be with decimal comma and 3 decimal places.
The quotes are necessary because of the whitespace in the column name.

More Examples