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 all values list for the selected field), or some “special” fixed values, such as “NULL”
- Operator: Arithmetic, logical, comparator or conditional Operators. Many of them can be applied to numeric values but also to text, dates, etc. For example, the “+” operator will return the sum of two numeric values, but it will also return 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 will be applied to objects attached to the Source Table
- Advanced: 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 viceversa: ‘ST’ <–> ‘Street’ , ‘DR’ <–> ‘Drive’
2. Creation of new Fields as result of operations between fields, fixed values, geometry, etc.: Calculate new field with the area or perimeter of a polygon or closed polyline, get the lenght of a line, …
3. Complex and chained operations using all types of operators, functions and parameters: Fully customizable formated results, and easy programming control structures like conditions
Note: Some functionalities can be found in the Standard or Professional editions only
