Expressions - Evaluating String as Integers



Overview

Occasionally import files (CSV's and delimited files) contain numerical values as string. This can be for quantity, price, etc. So this needs to be handled slightly differently to normal columns. To do this the column can be surrounded by v{}

Example 1

v{ColumnName}

Example 2 - Evaluating against a string and removing the additional decimal places

replace[v{ColumnName},".00",""]
See Also
Template Designer Expressions
Macros - Automated Tasks_deleted
Expressions