Create a singular property by concatenating multiple fields’ data to come up with a calculated property.
The calculated properties can be added from the Project Setup for both P&ID and 3D piping classes.
Functions
- Substring
- Retrieves characters from a string.
- ToUpper
- Converts all letters in the specified string to uppercase.
- ToLower
- Converts all letters in the specified string to lowercase.
- ToString
- Converts from hierarchy ID to a string type.
- ToNumber
- Converts expression to a value of a NUMBER data type.
- Round
- Returns a number rounded to a certain number of decimal places.
- Split
- Splits the string in the first argument by the separator in the second argument.
- Trim
- Removes the space character from both the start and end of the string.
You can choose Calculated type when adding new properties from Project Setup.
In the Add Calculated Property dialog box, you can choose existing functions and operator symbols to concatenate multiple properties. The calculated property expressions display on the right pane. You can also directly enter the SQL expression.
Sample expression: ToUpper(Service) ||('-') || LineNumberTag || ('-') ||Spec
Calculated property result:
Note: The double bar "||" is used to separate each field or text. Text or special symbols must be encapsulated by parentheses and a single quote (for example, ('text')).