Page Comparison

Supported Message Center (MC) Functions

Anchor
function_mc_atof function_mc_atof

MC Function: Atof

Format

atof( object[, decsep = '.'[, thoussep=',']] )

Arguments Types

Return Type

Returns Value

• Converts its first parameter object of type String to type Double, taking its second parameter decsep as decimal separator and its third parameter thoussep as thousands separator. If separators are indicated, then during conversion, these symbols are omitted, that is, not taken into consideration. The default value for parameter decsep is '.', for parameter thoussep – ','.
• If parameters have types other than those needed, zero (0.0) is returned.

Examples

Anchor
function_mc_atoi function_mc_atoi

MC Function: Atoi   

Format

atoi( object )

Arguments Types

Return Type

Returns Value

• Converts its parameter object of type String to type Integer
• If parameters have types other than those needed, zero (0) is returned

Examples

Anchor
function_mc_atol function_mc_atol

MC Function: Atol  

Format

atol( object )

Arguments Types

Return Type

Returns Value

• Converts is parameter object of type String to type Long
• Of parameters have types other than those needed, zero (0) is returned

Examples

Anchor
function_mc_convert function_mc_convert

MC Function: Convert  

Format

convert( object, p2[, p3[, p4[, p5[, p6]]]])

Arguments Types

Return Type

Returns Value

• If object is of type String, then it is returned unchanged no matter what values the other parameters include.
• If object is of type Date, then p2 must have type String representing format, according to which object is represented as string.

Examples

Anchor
function_mc_countstrings function_mc_countstrings

MC Function: CountStrings  

Format

CountStrings(countStringsObject, countStringsWhat, countStringsStart, countStringsHowMuch) 

Returns Value

Returns how many times string, specified by its 2nd parameter (countStringsWhat), occurs in the strings, specified by its 1st parameter (countStringsObject). Starting position is indicated by the 3rd parameter (countStringsStart) and the range of symbols within the search should be performed is defined by the 4th parameter (countStringsHowMuch).

Examples

Anchor
function_mc_createvariable function_mc_createvariable

MC Function: CreateVariable  

Format

CreateVariable( varName, varValue):

Returns Value

Assigns expression indicated as a second parameter (varValue) and stores it for further usage under the name that the first expression evaluates too (varName).

Examples

Anchor
function_mc_currenttime function_mc_currenttime

MC Function: CurrentTime   

Format

CurrentTime( )

Return Type

Returns Value

Returns value of type Time for the current time in the format hh:mm:ss.uuu.

Examples

Anchor
function_mc_date function_mc_date

MC Function: Date  

Format

Date( object,  format )

Arguments Types

Return Type

Returns Value

• Makes an attempt to convert the string that is contained in object using the format, to type Date.
• The format string can contain the following special symbols:
  • object – String
  • format – String
  • y – For year representation.
  • m – For month representation.
  • d – For day in the month representation.
• The number of consecutive special letters indicates the maximum number of digits in the corresponding area.
  For example, mm indicates that the number of the month contains at a maximum, two digits, but it can contain less too. All of this is done to enable the leading zeroes to be omitted. If any of these fields are omitted, the default values of the current date are taken. Other symbols in the format string are not taken into consideration, but the corresponding symbol must be present in the date string too. Otherwise, the date is considered to be in the incorrect format.
  For example, date('14.05.1973', 'dd/mm/yyyy') causes an error because the delimiter in the format does not match the actual one in the date ('.' instead of '/'). If the given data is an incorrect date, the object is marked as containing an invalid date.

Anchor
fucntion_mc_dayofweek fucntion_mc_dayofweek

MC Function: DayOfWeek/DayOfWeekNr/DayOfWeekShrt  

Format

dayOfWeek (dateData)
dayOfWeekNr (dateData)
dayOfWeekShrt (dateData)

Arguments Types

Return Type

Returns Value

• DayOfWeek: Returns day of week from the specified parameter of type Date.
• DayOfWeekNr: Returns day of week number from the specified parameter of type Date.
• DayOfWeekShrt: Returns day of week abbreviation from the specified parameter of type Date.
• If a parameter has a type other than what is needed, zero is returned.

Anchor
function_mc_executemethod function_mc_executemethod

MC Function: ExecuteMethod   

Format

executeMethod( methodName )

Arguments Types

Return Type

Returns Value

• Makes an attempt to execute the method specified by the string methodName. If the attempt is successful, the result of the method execution is returned, having the type and the value defined by the method of execution. If the attempt fails, stated by the message "...there is no such method…," the object of type Undefined is returned.
• If a parameter has a type other than what is needed, the object of type Undefined is returned.

Examples

Anchor
function_mc_find function_mc_find

MC Function: Find   

Format

find( findWhere , findWhat[, startPos = "0", [occurrence= "1"]]);

Arguments Types

Return Type

Returns Value

• Searches position of the n-the occurrence of the findWhat in findWhere beginning the position startPos, and returns the index. If where is not found, the return index is equal to -1. If start is omitted or is negative, the search is done from the beginning of findWhere. If occurrence is omitted, the first occurrence is returned.
• If parameter types differ from those needed, an empty string is returned.

Examples

Anchor
function_mc_getday function_mc_getday

MC Function: GetDay/GetMonth/GetYear   

Format

getDay(object)
getMonth(object)
getYear(object)

Arguments Types

Return Type

Returns Value

• Returns the day of the day/month/year for the object respectively.
• If a parameter has a type other than what is needed, zero is returned.

Anchor
function_mc_getdirroot function_mc_getdirroot

MC Function: GetDirRoot   

Format

GetDirRoot ()

Return Type

Returns Value

• Returns service root directory.

Anchor
function_mc_getline function_mc_getline

MC Function: GetLine  

Format

getLine(object[, lineNo = "1"[, pos= "1"]]);

Arguments Types

Return Type

Returns Value

• Returns the line, which number is specified in the second parameter lineNo, starting with position indicated by its third parameter pos from the original object of type String, specified by its first parameter object.
• If lineNo is omitted, or is negative, it is assumed that lineNo is equal to 1.
• If pos is omitted, or is negative, it is assumed that pos is equal to 0 (start of the string).
• If parameter types differ from those needed, an empty string is returned.

Examples

Anchor
function_mc_getlines function_mc_getlines

MC Function: GetLines   

Format

getLines(object[, startLine[, howMuch]]);

Arguments Types

Return Type

Returns Value

Returns SimpleString that contains at much number of lines, specified by third parameter howMuch, starting with line number specified by second parameter startLine (1 based), from the object, specified by its first parameter object.

• If startLine is omitted, or is negative, it is assumed that startLine is equal to 1.
• If startLine is bigger than the number of lines, an empty string is returned.
• If there is no line with indicated line number, lineNo, or if position pos indicates after the end of the string, an empty string is returned.
• If parameter types differ from those needed, an empty string is returned.

Examples

Anchor
function_mc_getplatform function_mc_getplatform

MC Function: GetPlatform 

Format

GetPlatform ()

Return Type

Returns Value

• Returns OS type (WIN or UNIX).

Examples

Anchor
function_mc_guid function_mc_guid

MC Function: GUID   

Format

GUID( )

Returns Value

• Returns the string type identifier for the indicated expression.

Examples

Anchor
function_mc_gettypename function_mc_gettypename

MC Function: GetTypeName   

Format

GetTypeName(expr)

Returns Value

• Returns the string type identifier for the indicated expression.

Examples

Anchor
function_mc_if function_mc_if

MC Function: If   

Format

IF (expression) THEN [statements_if_true;] ELSE [statements_if_false;]

Arguments Types

Return Type

Returns Value

This function conditionally executes a group of statements, depending on the value of an expression.

Examples

Anchor
function_mc_iif function_mc_iif

MC Function: Iif   

Format

iif(logexpr, result_if_true, result_if_false)

Arguments Types

Return Type

Returns Value

• Any value can be returned.
• If parameter logical_expression evaluates to true, returns second parameter result_if_true, otherwise third parameter result_if_false is returned. The second and the third parameters should (but not must) be of the same type.
• The logical expression is true only if it is:
  • Of type Date, and the date is valid,
  • Of type Time, and the time is valid,
  • Of time, String, and the string is non-empty, and
  • Of one of numeric type Integer, Double, or Long, and contains non-zero.

Examples

Anchor
function_mc_isalpha function_mc_isalpha

MC Function: IsAlpha   

Format

isAlpha(object_to_test)

Arguments Types

Return Type

Returns Value

• Returns true (non-zero) if the specified parameter (object_to_test) is alpha: consists only from letters.
• If a parameter has a type other than what is needed, zero is returned.

Examples

Anchor
function_mc_isalphanumeric function_mc_isalphanumeric

MC Function: IsAlphaNumeric   

Format

isAlphaNumeric(object_to_test [,separator= ","])

Arguments Types

Return Type

Returns Value

• Returns true (non-zero) if the first specified parameter (object_to_test) is alpha-numeric: consists only from letters and digits and at maximum one presence of decimal point separator (indicated by second parameter).
• If a parameter has a type other than what is needed, zero is returned.

Examples

Anchor
function_mc_isdefined function_mc_isdefined

MC Function: IsDefined   

Format

isDefined(varName)

Arguments Types

Return Type

Returns Value

• Returns true (non-zero) if the variable, indicated by its parameter varname, is defined.
• If parameters have types other than those needed, 0 (zero) is returned.

Anchor
function_mc_isnull function_mc_isnull

MC Function: IsNull 

Format

isNull(object)

Arguments Types

Return Type

Returns Value

• Returns true (non-zero) if the specified parameter object has type Null.

Examples

Anchor
function_mc_isnumeric function_mc_isnumeric

MC Function: IsNumeric  

Format

isNumeric(object_to_test[, separator= ","])

Arguments Types

Return Type

Returns Value

• Returns true (non-zero) if the first specified parameter (object_to_test) is numeric: consists only from digits and at maximum one presence of decimal point separator (indicated by second parameter).
• If a parameter has a type other than what is needed, zero is returned.

Examples

Anchor
function_mc_left function_mc_left

MC Function: Left  

Format

LEFT(left_object, left_howMuch)

Arguments Types

Return Type

Returns Value

• Returns left substring of its first parameter (left_object), having at much number of characters, indicated by its second parameter (left_howMuch). Attempts to convert parameters to needed types in contrast to SubString.

Examples

Anchor
function_mc_lower function_mc_lower

MC Function: Lower   

Format

Lower(object[, startPos = "0"[, howMuch = "-1"]])

Arguments Types

Return Type

Returns Value

• Changes the case of symbol to lowercase in the object, specified by its first parameter object, starting with position indicated by its second parameter startPos, and maximum number of changes, specified by its third parameter howMuch, are made.
• If startPos is omitted, or is negative, it is assumed to be equal to the start of the string.
• If howMuch is omitted, or is negative, it is assumed that all symbols must change the case.
• If parameter types differ from those needed, an empty string is returned.

Examples

Anchor
function_mc_makenumber function_mc_makenumber

MC Function: MakeNumber   

Format

MakeNumber( expr1, expr2 )

Returns Value

• This function creates the number from a specified mantissa and exponent.

Anchor
function_mc_mid function_mc_mid

MC Function: Mid   

Format

Mid( midObject, midStart, midHowMuch )

Return Type

Returns Value

• This function returns the substring of its first parameter, starting at the position specified by the first parameter. The length of the resulting string is indicated by the third parameter.

Anchor
function_mc_nooflines function_mc_nooflines

MC Function: NoOfLines   

Format

NoOfLines( expr )

Return Type

Returns Value

• The number of lines (base 1) the expression contains.
• If parameters have types other than those needed, 0 is returned.

Anchor
function_mc_nop function_mc_nop

MC Function: Nop  

Format

Nop()

Return Type

Returns Value

• The value of type Undefined is always returned.
• This is a non-operation function. It is required under certain circumstances because its execution speed is fast. It is recommended for use over other functions.
• Typically, this function is used in iif, and only when the action for one of two conditions exists.

Examples

Anchor
function_mc_padleft function_mc_padleft

MC Function: PadLeft  

Format

PadLeft( padObject, padChar, padMaxLen )

Return Type

Returns Value

• This function pads objects from the left side with a symbol, specified in the second parameter, so that the resulting string has at a minimum, the padMaxLen symbols.

Anchor
function_mc_padright function_mc_padright

MC Function: PadRight   

Format

PadRight( padObject, padChar, padMaxLen )

Return Type

Returns Value

• This function pads objects from the right side with a symbol, specified in the second parameter, so that the resulting string has at a minimum, the padMaxLen symbols.

Anchor
function_mc_removemethod function_mc_removemethod

MC Function: RemoveMethod   

Format

RemoveMethod( name )

Arguments Types

Return Type

Returns Value

• Makes an attempt to remove the already compiled method with a name.
• If the method was found and successfully removed, one (1) is returned. Otherwise, zero (0) is returned.
• If parameters have types other than those needed, zero (0) is returned.

Anchor
function_mc_replace function_mc_replace

MC Function: Replace   

Format

Replace( object, what, with[, from[, howMuch]] )

Arguments Types

Return Type

Returns Value

• Substitutes howMuch occurrences of the string what, with the string with, starting with position from in object. The result of the substitution is returned.
• If From is omitted, or is negative, it is assumed that its value is 0, the start of the string.
• If howMuch is omitted, or is negative, it is assumed to replace all occurrences of what with with.
• If parameter types differ from those needed, an empty string is returned.

Anchor
function_mc_rfind function_mc_rfind

MC Function: RFind  

Format

RFind( findWhere, FindWhat, startPos='-1', occurrence='1' )

Returns Value

• This function searches the backward position of the n-th occurrence of the second parameter in its first parameter, beginning with the position specified in its third parameter.

Anchor
function_mc_right function_mc_right

MC Function: Right  

Format

Right( rightObject, rightHowMuch )

Returns Value

• This function returns the right substring of its first parameter, the length of the resulting string indicated by the second parameter. If the length of the original string is less than the second parameter, the original string is returned unchanged

Anchor
function_mc_setmethod function_mc_setmethod

MC Function: SetMethod   

Format

SetMethod( name, code )

Return Type

Returns Value

• Makes an attempt to compile expression code, and if the compilation is successful, associates the compiled expression with the method name. If there is already an existing compiled expression with this name, it is overwritten. This is done only in the case where the code is different from the code of the newly compiled expression. This is to avoid having to compile the same compiled expression twice.
• Upon the successful creation of methods, one (1) is returned. Otherwise, zero (0) is returned.
• If parameters have types other than those needed, zero (0) is returned.

Anchor
function_mc_stringlength function_mc_stringlength

MC Function: StringLength  

Format

StringLength( expr )

Return Type

Returns Value

• The length of the expression expr if it is of type String. Otherwise, it returns 0.

Anchor
function_mc_substring function_mc_substring

MC Function: SubString   

Format

SubString( object, [start[, howMuch]] )

Arguments Types

Return Type

Returns Value

• Returns the substring of the string object starting with position start and containing howMuchcharacters.
• If start is omitted, or is negative, it is assumed that start is equal to 0.
• If howMuch is omitted, or is negative, howMuch is assumed to be the length of the string.
• If start is omitted, or is negative, it is assumed that start is equal to 0.
• If start+howMuch is bigger than the length of the string, all characters are taken from the position start until the end of the string.
• If parameter types differ from those needed, an empty string is returned.

Anchor
function_mc_time function_mc_time

MC Function: Time   

Format

Time( object, format )

Arguments Types

Return Type

Returns Value

• Makes an attempt to convert the string contained in object using the format format, to type Time.
• Format string can contain the following special symbols:
  • h – for hours representation.
  • m – for minutes representation.
  • s – for seconds representation.
• The number of consecutive special letters indicates the maximum number of digits in the corresponding area. For example, mm indicates that the number of minutes contains two digits maximum, but can still contain fewer digits. This is done to allow leading zeroes be omitted. If any of the fields are omitted, the default value (current date) is returned.
• Other symbols in the format string are not taken into consideration, but the corresponding symbol must be present in the date string too. Otherwise, the date is considered to be of incorrect format.
  For example, ('14:05:33', 'hh/mm/ss') returns an error because the delimiter in the format does not match the actual one in the date, using '.' instead of '/'. If the given data is incorrect time, the object is marked as containing invalid time.

Anchor
function_mc_today function_mc_today

MC Function: Today   

Format

Today()

Return Type

Returns Value

• Returns the current day value of type Date.

Anchor
function_mc_trim function_mc_trim

MC Function: Trim   

Format

Trim( object )

Arguments Types

Return Type

Returns Value

• Removes the leading and trailing blank characters from the specified string object and returns the resulting object.
• If parameter types differ from those needed, an empty string is returned.

Anchor
function_mc_upper function_mc_upper

MC Function: Upper   

Format

Upper( object[, startPos[, howMuch]] )

Arguments Types

Return Type

Returns Value

• Changes the case of the symbols in string object starting with position startPos. At a maximum, howMuchcharacters change the case.
• Removes the leading and trailing blank characters from the specified string object and returns the resulting object.
• If parameter types differ from those needed, an empty string is returned.

Supported XSLT Functions

Anchor
function_xslt_addifnotnull function_xslt_addifnotnull

XSLT Function: AddIfNotNull   

Format

AddIfNotNull;

Returns Value

• A service command, based on the xsl:if block. If all aliases linked with a node containing the expression with AddIfNotNull are not empty, it is added to the result xml. If the aliases are empty, the node is not added.

Examples

Anchor
function_xslt_boolean function_xslt_boolean

XSLT Function: Boolean   

Format

boolean( object )

Arguments Types

Return Type

Returns Value

• Returns the boolean representation of the object argument.

Examples

Anchor
function_xslt_ceiling function_xslt_ceiling

XSLT Function: Ceiling   

Format

Ceiling( number )

Arguments Types

Return Type

Returns Value

• Returns the smallest integer value not less than the argument.

Examples

Anchor
function_xslt_concat function_xslt_concat

XSLT Function: Concat   

Format

Concat( string, string, string* )

Arguments Types

Return Type

Returns Value

• Returns the concatenation of its arguments.

Examples

Anchor
function_xslt_contains function_xslt_contains

XSLT Function: Contains   

Format

Contains( string, string )

Arguments Types

Return Type

Returns Value

• Returns TRUE if the first argument string contains the second argument string.

Examples

Anchor
function_xslt_convertdate function_xslt_convertdate

XSLT Function: ConvertDate   

Format

ConvertDate( date, inFormat, outFormat )

Arguments Types

Return Type

Returns Value

• Convert the date with format inFormat to new date (as string) with format outFormat.

  Warning
  icon false
  Current version supports only converting from \"M?/D?/YYYY h?:m?:s?\" to \"YYYY-MM-DD\".

  
  

Examples

Anchor
function_xslt_count function_xslt_count

XSLT Function: Count   

Format

Count( node-set )

Arguments Types

Return Type

Returns Value

• Returns the number of nodes in the node-set.

Examples

Anchor
function_xslt_describexsltvar function_xslt_describexsltvar

XSLT Function: DescribeXSLTVar   

Format

DescribeXSLTVar( var )

Return Type

Returns Value

• Service command to describe XSLT Variable in the block above. By default, all xslt variables, declared in the worksheet, describing in the header of XSLT document. But if you need describe a xslt variable inside a block of elements (for example, inside ForEach block), please, use this function.

Examples

Anchor
function_xslt_false function_xslt_false

XSLT Function: False   

Format

False( )

Return Type

Returns Value

• Returns a boolean with the value of false.

Examples

Anchor
function_xslt_floor function_xslt_floor

XSLT Function: Floor   

Format

Floor( number )

Arguments Types

Return Type

Returns Value

• Returns the largest integer value not greater than the argument.

Examples

Anchor
function_xslt_id function_xslt_id

XSLT Function: Id   

Format

Id( object )

Arguments Types

Return Type

Returns Value

• Returns the element specified by it's unique Id.

Examples

Anchor
function_xslt_if function_xslt_if

XSLT Function: If..Then..Else  

Format

If( condition ) Then [value];;Else [value];;

Returns Value

• A service command to add a xsl:choose block with inner xsl:when and xsl:otherwise blocks. Please adapt all values in [] to your custom case and set the condition correctly. You can use any number of 'If-Then' pairs in an expression, but only one 'Else' is allowed.

  Warning
  icon false
  You should use single quotes in the condition because the const value is of string format, but after the 'Then' keyword single quotes are used because of char (part of string value) format.

  
  

  Info
  title Note
  The Else block is optional. Function name is not case sensitive.

  
  

Examples

Anchor
function_xslt_lang function_xslt_lang

XSLT Function: Lang   

Format

Lang( string )

Arguments Types

Return Type

Returns Value

• Returns true if the language of the context node matches the language specified by the argument.

Examples

Anchor
function_xslt_last function_xslt_last

XSLT Function: Last   

Format

Last()

Return Type

Returns Value

• Returns the position of the last node in the context list.

Examples

Anchor
function_xslt_local-name function_xslt_local-name

XSLT Function: Local-name  

Format

Local-name( node-set )

Arguments Types

Return Type

Returns Value

• Returns the local-name for the first node in the node-set.

Examples

Anchor
function_xslt_name function_xslt_name

XSLT Function: Name   

Format

Name( node-set )

Arguments Types

Return Type

Returns Value

• Returns the name for the first node in the node-set.

Examples

Anchor
function_xslt_namespace-uri function_xslt_namespace-uri

XSLT Function: Namespace-uri 

Format

Namespace-uri( node-set )

Arguments Types

Return Type

Returns Value

• Returns the namespace-uri for the first node in the node-set.

Examples

Anchor
function_xslt_normalize-space function_xslt_normalize-space

XSLT Function: Normalize-space  

Format

Normalize-space( string )

Arguments Types

Return Type

Returns Value

• Returns a space normalized string specified by the argument.

Examples

Anchor
function_xslt_not function_xslt_not

XSLT Function: Not  

Format

Not( boolean )

Arguments Types

Return Type

Returns Value

• Returns a boolean with the opposite value of its argument.

Examples

Anchor
function_xslt_number function_xslt_number

XSLT Function: Number   

Format

Number( object )

Arguments Types

Return Type

Returns Value

• Returns the number representation of the object argument.

Examples

Anchor
function_xslt_position function_xslt_position

XSLT Function: Position   

Format

Position()

Return Type

Returns Value

• Returns the position of the current context node.

Examples

Anchor
function_xslt_round function_xslt_round

XSLT Function: Round   

Format

Round( number )

Arguments Types

Return Type

Returns Value

• Returns the integer value closest to the argument.

Examples

Anchor
function_xslt_starts-with function_xslt_starts-with

XSLT Function: Starts-with   

Format

Starts-with( string, string )

Arguments Types

Return Type

Returns Value

• Returns TRUE if the first argument string starts with the second argument string.

Examples

Anchor
function_xslt_string function_xslt_string

XSLT Function: String  

Format

String( object )

Arguments Types

Return Type

Returns Value

• Returns the string representation of the object argument.

Examples

Anchor
function_xslt_string-length function_xslt_string-length

XSLT Function: String-length  

Format

String-length( string )

Arguments Types

Return Type

Returns Value

• Returns the length of the string specified by the argument.

Examples

Anchor
function_xslt_substring function_xslt_substring

XSLT Function: Substring  

Format

Substring( string, number, number ) 

or

Substring( string, number )

Arguments Types

Return Type

Returns Value

• Returns the substring of the first argument starting at the position specified by the second argument and the length specified by the third argument.
  or
• Returns the substring of the first argument from the position specified by the second argument.

Examples

Anchor
function_xslt_substring-after function_xslt_substring-after

XSLT Function: Substring-after   

Format

Substring-after( string, string )

Arguments Types

Return Type

Returns Value

• Returns the substring of the first argument string that comes after the first occurrence of the second argument.

Examples

Anchor
function_xslt_substring-before function_xslt_substring-before

XSLT Function: Substring-before  

Format

Substring-before( string, string )

Arguments Types

Return Type

Returns Value

• Returns the substring of the first argument string that comes before the first occurrence of the second argument.

Examples

Anchor
function_xslt_sum function_xslt_sum

XSLT Function: Sum   

Format

Sum( node-set )

Arguments Types

Return Type

Returns Value

• Returns the sum of all nodes in the node-set.

Examples

Anchor
function_xslt_translate function_xslt_translate

XSLT Function: Translate   

Format

Translate( string, string, string )

Arguments Types

Return Type

Returns Value

• Replaces characters in the string specified by the second argument with characters specified by the third argument.

Examples

Anchor
function_xslt_true function_xslt_true

XSLT Function: True   

Format

True( )

Return Type

Returns Value

• Returns a boolean with the value of true.

Examples