CSVfox
Leverage Your Data.
 English

±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.
Under construction, coming soon