±prepend

Prepends a value before the beginning of the data field.
The value can be a literal, the contents of another field, or any expression.
For inserting or prepending a whole new field to the data row, use ±add.
 

Pattern

Usage

-prepend[FieldName]=Today:\s

Prepends "Today: " before the contents of the column FieldName .
The \s stands for a whitepace character.
 

-prepend[NetPrice],[GrossPrice]=USD

Prepends the value " USD"  to both fields NetPrice and GrossPrice.
 

-prepend[NetPrice],[GrossPrice]=[Currency]\s

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

Example

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

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

Prepends 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