Difference between revisions of "Translations:CSV Importing Guide/12/en"
(Importing a new version from external source) |
(Importing a new version from external source) |
||
Line 1: | Line 1: | ||
To create expressions in CSV files the following rules must be observed: | To create expressions in CSV files the following rules must be observed: | ||
* The expression must begin with the character '''equal''' and be enclosed in '''parentheses'''. Examples: ''=(Price/Quantity)'', ''=((Profit*100)/Price)'' | * The expression must begin with the character '''equal''' and be enclosed in '''parentheses'''. Examples: ''=(Price/Quantity)'', ''=((Profit*100)/Price)'' | ||
− | * To reference other columns in the file, use the column/header name | + | * To reference other columns in the file, use the double-quoted column/header name |
* It is not necessary to have data in the other rows for expression columns, as the content will be the result of the expression | * It is not necessary to have data in the other rows for expression columns, as the content will be the result of the expression |
Revision as of 04:15, 8 August 2019
To create expressions in CSV files the following rules must be observed:
- The expression must begin with the character equal and be enclosed in parentheses. Examples: =(Price/Quantity), =((Profit*100)/Price)
- To reference other columns in the file, use the double-quoted column/header name
- It is not necessary to have data in the other rows for expression columns, as the content will be the result of the expression