Perform calculations on new or existing field values by applying a wide range of operators and functions, such as arithmetic operations (addition, subtraction, multiplication, division), mathematical functions (square root, logarithms, trigonometric functions) and date manipulations. These expressions can incorporate constant values as well as values retrieved from other fields within the table. This allows for dynamic and complex data transformations and analyses within the table’s dataset.
Available for AutoCAD, BricsCAD, ZWCAD, GstarCAD and Desktop.
Available Expressions
- Field: To select any field name defined in the Source Table
- Values: To select any value from a selected field in the Source Table (you will see the list of values for the selected field), or some “special” fixed values such as “NULL”
- Operator: Arithmetic, logical, comparator or conditional operators. Many can be applied to numeric values and also to text, dates etc. For example, the “+” operator returns the sum of two numeric values but also returns the concatenation of two texts
- Math: Mathematical functions such as logarithmic or trigonometric expressions, rounding, square roots etc.
- Text: Text functions such as full or partial text replacement, convert numerical values to text, split texts etc.
- Date: Date functions such as hourly, daily or monthly calculations etc.
- Geometry: Functions applicable to object geometries such as area calculations, elevations etc. They are applied to objects attached to the Source Table
- Advanced: A set of advanced functions not included in the previous sections such as creating lists, returning values from one list based on the values of another list etc.
Samples
1. Simple Text replacement in a Field: Replace abbreviations on addresses with the complete text or vice versa: ‘ST’ <–> ‘Street’ and ‘DR’ <–> ‘Drive’
2. Creation of new Fields as result of operations between fields, fixed values, geometry etc.: Calculate a new field with the area or perimeter of a polygon or closed polyline or get the length of a line.
3. Complex and chained operations using all types of operators, functions and parameters: Fully customizable formatted results and simple control structures like conditions
Note: Some features are available only in the Standard or Professional editions.
