Function Description * Note: Parameter is the value of the field involved in the construction of the expression.
Abs
Abs(Parameter)
Returns the absolute value of a number.
Sqrt
Sqrt(Parameter)
Returns the square root of a number (Double).
Ln
Ln(Parameter)
Returns the natural logarithm of a number (Double).
Log
Log(Parameter)
Returns the logarithm of a number (Double).
Int
Int(Parameter)
Returns the integer (whole number) portion of a number.
ObjectCenterX
ObjectCenterX()
Returns the x coordinate of the geometric object's centroid (Double). If the field to update is in integer, the Int function will be applied to a value before assigning the value to a cell in the field.
For a cell within the update range, its updated value is the x coordinate of the centroid of the geometric object corresponding to the cell.
ObjectCenterY
ObjectCenterY()
Returns the y coordinate of the geometric object's centroid (Double). If the field to update is in integer, the Int function will be applied to a value before assigning the value to a cell in the field.
For a cell within the update range, its updated value is the y coordinate of the centroid of the geometric object corresponding to the cell.
ObjectLeft
ObjectLeft()
Returns the x coordinate of the geometric object's left border (Double). If the field to update is in integer, the Int function will be applied to a value before assigning the value to a cell in the field.
For a cell within the update range, its updated value is the x coordinate of the left border of the geometric object corresponding to the cell.
ObjectRight
ObjectRight()
Returns the x coordinate of the geometric object's right border (Double). If the field to update is in integer, the Int function will be applied to a value before assigning the value to a cell in the field.
For a cell within the update range, its updated value is the x coordinate of the right border of the geometric object corresponding to the cell.
ObjectTop
ObjectTop()
Returns the y coordinate of the geometric object's top border (Double). If the field to update is in integer, the Int function will be applied to a value before assigning the value to a cell in the field.
For a cell within the update range, its updated value is the y coordinate of the top border of the geometric object corresponding to the cell.
ObjectBottom
ObjectBottom()
Returns the y coordinate of the geometric object's bottom border (Double). If the field to update is in integer, the Int function will be applied to a value before assigning the value to a cell in the field.
For a cell within the update range, its updated value is the y coordinate of the bottom border of the geometric object corresponding to the cell.
ObjectWidth
ObjectWidth()
Returns the width of the geometric object (Double). If the field to update is in integer, the Int function will be applied to a value before assigning the value to a cell in the field.
For a cell within the update range, its updated value is the width of the geometric object corresponding to the cell.
ObjectHeight
ObjectHeight()
Returns the height of the geometric object (Double). If the field to update is in integer, the Int function will be applied to a value before assigning the value to a cell in the field.
For a cell within the update range, its updated value is the height of the geometric object corresponding to the cell.
Function Description * Note: Parameter is the value of the field involved in the construction of the expression. otherParameter, otherParameter1, and otherParameter2 are the values specified in the text boxes to the right of the Operator combo box in the Update Fiedl dialog box.
Left
Parameter.Left(otherParameter)
Returns a string containing a specified number of characters from the left side of a string. If the specified number otherParameter is greater than the total length of the string, the original string will be returned.
otherParameter is a positive integer.
Right
Parameter.Right(otherParameter)
Returns a string containing a specified number of characters from the left side of a string. If the specified number otherParameter is greater than the total length of the string, the original string will be returned.
otherParameter is a positive integer.
Mid
Parameter.Mid(otherParameter1, otherParameter2)
Returns a substring of a string based on the starting and ending positions. If the starting position otherParameter1 is greater than the length of the string, the original string will be returned. If the ending position otherParameter2 is greater than the length of the string, the substring from the starting position will be returned. The position starts at 0.
otherParameter1 and otherParameter2 are positive integers.
UCase
Parameter.UCase()
Converts all letters in the specified string to uppercase.
Lcase
Parameter.Lcase()
Converts all letters in the specified string to lowercase.
Trim
Parameter.Trim()
Returns a string containing a copy of a specified string with no leading and trailing spaces.
TrimEnd
Parameter.TrimEnd(otherParameter)
Removes the specified characters from the end of the string.
For example, when Parameter ="efgabc" and otherParameter="abc", Parameter.TrimEnd('a','b','c')="eft".
otherParameter is the specified characters.
TrimStart
Parameter.TrimStart(otherParameter)
Removes the specified characters from the start of the string.
For example, when Parameter ="efgabc" and otherParameter="efg", Parameter.TrimEnd('a','b','c')="abc".
otherParameter is the specified characters.
LRemove
Parameter.LRemove(otherParameter)
Removes a number of characters from the start of a string.
otherParameter is a positive integer indicating the number of characters you want to remove.
RRemove
Parameter.RRemove(otherParameter)
Removes a number of characters from the end of a string.
otherParameter is a positive integer indicating the number of characters you want to remove.
Replace
Parameter.Replace(otherParameter1, otherParameter2)
Replaces a sequence of characters in a string with another set of characters.
Parameter is the string to replace a sequence of characters with another set of characters. otherParameter1 is the string that will be searched for in Parameter. otherParameter2 is the string to replace otherParameter1.
Function Description * Note: If the operation field is of Date type and the field to update is not, the supported functions include: DaysInMonth, Second, Minute, Hour, Day, Month, Year, DayOfYear, DayOfWeek.
* Note: If the field to update is of Date type and the operation field is not, the supported functions include: AddDays, AddHours, AddMilliseconds, AddMinutes, AddMonths, AddSeconds, AddYears, Date, Now.
* Note: Parameter is the value of the field involved in the construction of the expression and is in Date type. otherParameter, otherParameter1, and otherParameter2 are the values specified in the text boxes to the right of the Operator combo box in the Update Fiedl dialog box.
AddDays
Parameter.AddDays(otherParameter)
Returns a new date value based on adding a number of days to the specified date. If the interval otherParameter is negative, the result date would be earlier than the original date Parameter.
otherParameter is an integer.
AddHours
Parameter.AddHours(otherParameter)
Returns a new date value based on adding a number of hours to the specified date. If the interval otherParameter is negative, the result date would be earlier than the original date Parameter.
otherParameter is an integer.
AddMilliseconds
Parameter.AddMilliseconds(otherParameter)
Returns a new date value based on adding a number of milliseconds to the specified date. If the interval otherParameter is negative, the result date would be earlier than the original date Parameter.
otherParameter is an integer.
AddMinutes
Parameter.AddMinutes(otherParameter)
Returns a new date value based on adding a number of minutes to the specified date. If the interval otherParameter is negative, the result date would be earlier than the original date Parameter.
otherParameter is an integer.
AddMonths
Parameter.AddMonths(otherParameter)
Returns a new date value based on adding a number of months to the specified date. If the interval otherParameter is negative, the result date would be earlier than the original date Parameter.
otherParameter is an integer.
AddSeconds
Parameter.AddSeconds(otherParameter)
Returns a new date value based on adding a number of seconds to the specified date. If the interval otherParameter is negative, the result date would be earlier than the original date Parameter.
otherParameter is an integer.
AddYears
Parameter.AddYears(otherParameter)
Returns a new date value based on adding a number of years to the specified date. If the interval otherParameter is negative, the result date would be earlier than the original date Parameter.
otherParameter is an integer.
Date
Parameter.Date()
Returns the date part of the specified date.
Now
Parameter.Now()
Gets current data and time.
DaysInMonth
Parameter.DaysInMonth()
Returns the number of days in the specified date.
Second
Parameter.Second()
Returns the second part of the specified date.
Minute
Parameter.Minute()
Returns the minute part of the specified date.
Hour
Parameter.Hour()
Returns the hour part of the specified date.
Day
Parameter.Day()
Returns the day part of the specified date.
Month
Parameter.Month()
Returns the month part of the specified date.
Year
Parameter.Year()
Returns the year part of the specified date.
DayOfYear
Parameter.DayOfYear()
Returns an integer indicating which day of the year the specified date is in.
DayOfWeek
Parameter.DayOfWeek()
Returns an integer indicating which day of the week the specified date is in.