Computed column .NET methods - HxGN SDx - Update 64

Computed column .NET methods - HxGN SDx - Update 64 - Administration & Configuration

Administration and Configuration of HxGN SDx

Language

English

Product

HxGN SDx

Search by Category

Administration & Configuration

SmartPlant Foundation / SDx Version

Microsoft .NET methods calculate some of the computed columns. The following table provides further details on how some computer columns function:

Function	Description
Concat	Concatenates a set of input strings.
Divide	Divides the first operand by the second operand and throws an exception if the divisor is 0.
IndexOf	Returns the character position of the value parameter if the specified string is found, or -1 if it is not found. If the value is empty, the returned value is 0 (zero).
Join	Returns a string that consists of the elements in the value delimited by the separator string. If the value is an empty array, the method returns an empty string "".
Left	Sets the startIndex parameter to 0. See Substring for further details.
Length	Returns the number of char objects in the current string object. This function does not return the number of Unicode characters, because a particular Unicode character might be represented by more than one char object (standard character).
Minus	Returns the difference between two double values.
Multiply	Calculates the product of its operands.
PadLeft	Returns a new string that is equivalent to this, but left-aligned and padded on the right with as many padding characters as needed to create a length of totalWidth. However, if totalWidth is less than the length of this, the method returns a reference to the existing instance. If totalWidth is equal to the length of this, the method returns a new string that is identical.
PadRight	Returns a new string that is equivalent to this instance, but left-aligned and padded on the right with as many padding characters as needed to create a length of totalWidth. However, if totalWidth is less than the length of this, the method returns a reference to the existing instance. If totalWidth is equal to the length of this value, the method returns a new string that is identical.
RegexMatch	Searches the specified input string for the first occurrence of the regular expression supplied in the pattern.
RegexReplace	Returns a new string that is identical to the input string, except that a replacement string takes the place of each matched string.
Replace	Returns a string that is equivalent to the current string, except that all instances of oldValue are replaced with newValue. If oldValue is not found in the current instance, the method returns the current instance unchanged. This function throws an exception if oldValue null is empty or null.
SubString	Returns a string object equivalent to the substring of the length specified in the length parameter, beginning at the starting index number in the current String object. -or- Returns an empty field if the startIndex parameter is equal to the length of the current object and length is 0 (zero).
Sum	Returns the sum of the two operands.
ToLower (Lowercase)	Returns the current string in lowercase.
ToUpper (Uppercase)	Returns the current string in uppercase.
Trim	Passes a single character. Removes all occurrences of the specified character from the beginning and end of the string.
TrimEnd	Passes a single character. Removes all occurrences of the specified character from the end of the current string object.
TrimStart	Passes a single character. Removes all occurrences of the specified character from the beginning of the string object.

For more information on Microsoft .NET methods and their operators, see https://msdn.microsoft.com.