±add

Adds one or more new columns next to an existing column of the data row, and optionally fills each of them with a value.
The value can be a literal, the contents of another field, or any expression.
If you want to insert the new column at a specific position, you must denote the existing column the new column shall be inserted before (or after).
If you want to append one or more columns at the end of the data row instead, then just leave off this reference.

Inserting a single Column

Pattern

Usage Examples

If there is a csv file:

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

Appends a new column Transport Weight to the data row, and fills it with the value of the field Product Weight * 1.05. The output shall be with decimal comma and 3 decimal places.
Hint: On the command line, the quotes are necessary because of the whitespace in the column names. When using a %job file, they can be omitted.

Now we have the csv table:

-add["Product ID"]@["Product Weight"]

Inserts a new empty column "Product ID" before the column "Product Weight". A subsequent field command can later be used to fill it with a value.

More examples

-add["Line Number"]@[1]=(#)

Inserts a new first column "Line Number" before the recent first column, and initializes it with the current data row number.