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 '''equal''' character, be enclosed in '''parentheses''' and the columns enclosed in '''quotation''' marks. Examples: ''=("Price"/"Quantity")'', ''=(("Profit"*100)/"Price")''
* To reference other columns in the file, use the double-quoted 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
Latest revision as of 13:44, 15 October 2019
To create expressions in CSV files the following rules must be observed:
The expression must begin with the equal character, be enclosed in parentheses and the columns enclosed in quotation marks. 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