±set
Sets one or more CSV table fields to a certain value
Description
This command sets one or more CSV table data fields content to a specific value.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 subdivided with the delimiter (standard is "/").
Setting a single Field Content
Pattern
±set[Field]=Some text ...
±set[Field]=[Other Field]
±set[Field]={expression}
Usage Examples
- -set[Flower]=Tulip
- Sets the field "Flower" to the literal string "Tulip".
- -set[Price]=([Price]*2)
- Sets the field "Price", which is a field with numeric content in local number format, to it's double value.
- -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.
Setting more Field Contents
Pattern
±set[Field],[Field]...=Some text ...
±set[Field1],[Field2]...=[Other Field1]/[Other Field2]
±set[Field]={expression}
Usage Examples
- -set[Flower],[Tree]=Tulip/Oak
- Sets the field "Flower" to "Tulip", and the field "Tree" to "Oak".
- -set[Price]=([Price]*2)
- Sets the field "Price", which is a field with numeric content in local number format, to it's double value.
- -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.