±init

Sets one or more CSV table fields to a certain value, if they are empty

Setting a single Field Content
Setting more Field Contents

Description

This command sets one or more CSV table data fields content to a specific value, but if the table field is empty.
This value can be a literal string, another field's content, or an expression.

If a set of two or more fields is denoted, there can be a single value or also a set of values of the same count. These values must then be given as a comma-separated list.

Setting a single Field Content

Pattern

±init[Field]=Some text ... ±init[Field]=[Other Field] ±init[Field]={expression}

Usage Examples

[insert table before-after, with empty fields to fill in]

-init[Flower]=Tulip: Sets the field "Flower" to the literal string "Tulip", if it was empty before.
-init[Price]=12: Sets the field "Price", which is an empty field until now, to the value "17".
-set[FullAddress]="[FirstName] [Lastname]\n[HouseNumer] [Street]\n[City] [PostalCode], [Country]": Sets the field "FullAddress" to a three-lines address format formed by several address detail fields, it it is still empty.

Setting more Field Contents

Pattern

±init[Field],[Field]...=Some text ... ±init[Field1],[Field2]...=[Other Field1],[Other Field2] ±init[Field]={expression}

Usage Examples

[Explain use of once-inited variables for keeping value over table rows]

[insert table before-after, with empty fields to fill in]

-init[Flower],[Tree]=Tulip/Oak: Sets the field "Flower" to "Tulip" if it is empty, and the field "Tree" to "Oak", if that one is empty.
-init[NetPrice],[GrossPrice]=17,([NetPrice]*[Tax]): Initializes the field "NetPrice" to the value "17" if it is empty, and also fills in the field "GrossPrice" to the value of NetPrice plus tax.
-init[FullAddress]="[FirstName] [Lastname]\n[HouseNumer] [Street]\n[City] [PostalCode], [Country]": Sets the field "FullAddress" to a three-lines address format formed by several address detail fields if it is empty yet.