CSVfox
Leverage Your Data.
 English

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