DescriptionInserts a new column before an existing column of the data row, and optionally fills it with a value.
The value can be a literal, the contents of another field, or any expression.
If you want to append a column at the end of the data row instead, then you can use ±add.
If there is a csv file:
|Product||Product Weight||Transport Weight|
- -insert["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.
|Product||Product ID||Product Weight||Transport Weight|
- -insert["Line Number"]@=(#)
- Inserts a new first column "Line Number" before the recent first column, and initializes it with the current data row number.