±set
Sets a CSV table field to a certain value
Description
This command sets a CSV table data field content to a specific value.This can be a literal string, another field's content, or an expression.
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.