Imagine you have a property that contains a data string, and you need to extract a section of the data into a new property.
How do you do it without having to manually enter the data into the new property?
It can be done by using the Substring function of the PLANTDEFINECALCPROPERTIES command:
So for example, you have a 6 digit property called TagCode for hand valves that includes a text prefix followed by a hyphen and then a number (eg, AA-101) and you would like to extract the number (101) into a new property without including the text prefix.
This can be achieved using the following syntax "Substring(TagCode,3,3)":
The resulting calculated property, is a new property, called TagAnno that only includes the last 3 digits from the TagCode property: