Page Comparison

Message Center supports only XSLT v1.0 functions approved by w3c.org.

We are extending the function list with our custom XSLT functions (indicated by red text). The following types of functions are supported and listed below:

Message Center (MC) functions
EBS specific functions

These additional functions are valid for EBS and IWS, but should not be used in IWS or Message Center Editor.

The following types of functions are supported and listed below:

Message Center (MC) functions

XSLT functions

To find a specific function, scroll down or click Message Center Functions or XSLT EBS Specific Functions on on the right to expand the list and select a function.

For information on the Evaluate Expression Tool, see How to Use Evaluate Expression.

Navigate the page:

Expand

title	Message Center Functions (click to expand):

Expand

title	XSLT EBS Specific Functions (click to expand):

Supported Message Center (MC) Functions

Anchor
function_mc_atof
function_mc_atof
MC Function: Atof

Format

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

Arguments Types

object	String
decsep - decimal separator	String
thoussep - thousands separator	String

Return Type

Double

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

Expression	Result
atof('11123,456', ',')	11123.456
atof('11123,456')	11123456
atof('11.123,456', ',', '.')	11123.456
atof('11.123,456', ',')	0 (Cannot convert as the thoussep not defined)
atof('11.123,456',)	0 (Cannot convert as the thoussep and decsep not defined)

Anchor
function_mc_atoi
function_mc_atoi
MC Function: Atoi

Format

Code Block
atoi( object )

Arguments Types

object

String

Return Type

Integer

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

Expression	Result
atoi('11123')	11123
atoi('11123,456')	11123
atoi('abc')	0

Anchor
function_mc_atol
function_mc_atol
MC Function: Atol

Format

Code Block
atol( object )

Arguments Types

object

String

Return Type

Long

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

Expression	Result
atol('1231231231231231231')	1231231231231231231
atol('123123123123123,1231')	123123123123123
atol('abc')	0

Anchor
function_mc_convert
function_mc_convert
MC Function: Convert

Format

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

Arguments Types

object

p2

p3

p4

p5

p6

Return Type

String

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.

Info

title	Note

Format can have the following special symbols:

If object is of type Time, then p2 must have type String representing format, according to which object is represented as string.

Format can have the following special symbols:

Object has one of numeric types Integer, Long, or Double.

In this case, next types are assumed with their descriptions:
- A conversion of numeric type to string type is attempted by:
  - Using a specified thousand separator, if any,
  - Using a decimal separator, if any,
  - Grouping thousands by a specified number, and
  - If the number is negative, inserting a negative sign in front of the number.
  - If the negative character is '(', and the number is negative, the resulting string is enclosed in parenthesis. Otherwise, an empty string is returned.
  - If the negative character is "(", and the number is negative, the resulting string is enclosed in parenthesis. Otherwise, an empty string is returned.

Panel
yyyy – Replaced with 4 digit year. yy – Replaced with 2 digit year. mm – Replaced with month number. dd – Replaced with day in the month number. hh – Replaced with number of hours. mm – Replaced with number of minutes. ss – Replaced with number of seconds.

Panel
p2 Integer Contains the number of the decimal. p3 String Contains the decimal separator. If omitted, the default value \nis "." p4 String Contains the thousand separator. If omitted, the default value is "" (empty string). p5 Integer Contains the number of thousands to separate. If omitted, the default value is 3. p6 String Contains a negative sign. If omitted, the default value is "-";

Examples

Expression	Result
convert(123456, 3, ".", ",", 3, "-")	'123,456.000'
Default Value used (next 5 lines)
convert(-123456, 3, ".", ",", 3, "-")	'-123,456.000'
convert(-123456, 3, ".", ",", 3)	'-123,456.000'
convert(-123456, 3, ".", ",")	'-123,456.000'
convert(-123456, 3, ".")	'-123456.000'
convert(-123456, 3)	'-123,456.000'
convert(-123456l, 3, ".", "", 3, "(")	'(123456.000)'
convert(-123456l, 3, ".", ",", -3, "(")	'(123456.000)'
convert(-123456l, -3, ".", ",", 3, "(")	'(123,456)'
convert(-56l, -3, ".", ",", 3, "(")	'(56)'
convert(1234567890.987654321, 3, ".", ",", 3, "-")	'1,234,567,890.988'
convert(-1234567890.987654321, 3, ".", ",", 3, "-")	'-1,234,567,890.988'
convert(-1234567890.987654321, 3, ".", ",", 3, "(")	'(1,234,567,890.988)'
convert(0.0000987654321, 3, ".", ",", 3, "-")	'0.000'
Default Value used (next 5 lines)
convert(1234567890.9, 4, "-", "_", 2, "-")	'1_23_45_67_890-9000'
convert(-1234567890.9, 4, "-", "_", 2, "(")	'(1_23_45_67_890-9000)'
convert(-1234567890.9, 4, "-", "_", 2)	'-1_23_45_67_890-9000'
convert(-1234567890.9, 4, "-", "_")	'-1_234_567_890-9000'
convert(-1234567890.9, 4, "-")	'-1234567890-9000'
convert(-1234567890.9, 4)	'-1234567890.9000'
convert(-1234567890.987654321, 3, ".", ",", 3, "")	'-1,234,567,890.988'
convert(#12:15:45#, "hh/mm/ss")	'12/15/45'
convert(today(), "yyyy/mm/dd")	'2001/07/13'
convert(today(), "yy/mm/dd")	'01/07/13'
convert(today(), "Today is : dd-mm-yyyy")	'Today is : 13-07-2001'
convert(currentTime(), "hh:mm:ss.uuu")	'18:18:20.111'
convert("string", "hh:mm")	'string'

Anchor
function_mc_countstrings
function_mc_countstrings
MC Function: CountStrings

Format

Code Block
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

Expression	Result
CountStrings("122333444455555", "55")	2
CountStrings("1223334444", "NEW")	0

Anchor
function_mc_createvariable
function_mc_createvariable
MC Function: CreateVariable

Format

Code Block
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).

Info

title	Note

The assignment statement (:=) can also be used for creating a variable.

Examples

Expression

CreateVariable('var_1','123')

CreateVariable('var_2',:var_1:)

Anchor
function_mc_currenttime
function_mc_currenttime
MC Function: CurrentTime

Format

Code Block
CurrentTime( )

Return Type

Time

Returns Value

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

Examples

Expression	Result
CurrentTime()	01:41:59.035

Anchor
function_mc_date
function_mc_date
MC Function: Date

Format

Code Block
Date( object, format )

Arguments Types

object	String
format	String

Return Type

Date

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.

Expression	Result
Date('2014/10/16','yyyy/mm/dd'	10/16/2014
Date('2014/10/16','yyyy.mm.dd')	*cannot convert

Anchor
fucntion_mc_dayofweek
fucntion_mc_dayofweek
MC Function: DayOfWeek/DayOfWeekNr/DayOfWeekShrt

Format

Code Block
dayOfWeek (dateData) dayOfWeekNr (dateData) dayOfWeekShrt (dateData)

Arguments Types

DateData

Date

Return Type

String

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

Code Block
executeMethod( methodName )

Arguments Types

MethodName

String

Return Type

Any

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

Expression

ExecuteMethod('MyMethod')

Anchor
function_mc_find
function_mc_find
MC Function: Find

Format

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

Arguments Types

findWhere	String
findWhat	String
startPos	Integer
occurrence	Integer

Return Type

Integer

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

Expression	Result
Find('This is a string', 'string', 0, 1)	10
Find('This is a string', 'is', 0, 2)	5

Anchor
function_mc_getday
function_mc_getday
MC Function: GetDay/GetMonth/GetYear

Format

Code Block
getDay(object) getMonth(object) getYear(object)

Arguments Types

object

Date

Return Type

Integer

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

Code Block
GetDirRoot ()

Return Type

String

Returns Value

Returns service root directory.

Anchor
function_mc_getline
function_mc_getline
MC Function: GetLine

Format

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

Arguments Types

object	String
lineNo	Integer
pos	Integer

Return Type

String

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

Expression	Result
GetLine('abc\ndef\nghi',2,2)	'ef'

Anchor
function_mc_getlines
function_mc_getlines
MC Function: GetLines

Format

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

Arguments Types

object	String
startLine	Integer
howMuch	Integer

Return Type

String

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

Expression	Result
GetLines('aaa\nbbb\nccc',2,2)	'bbb ccc'

Anchor
function_mc_getplatform
function_mc_getplatform
MC Function: GetPlatform

Format

Code Block
GetPlatform ()

Return Type

String

Returns Value

Returns OS type (WIN or UNIX).

Examples

Expression	Result
GetPlatform()	'WIN'
GetPlatform()	'UNIX'

Anchor
function_mc_guid
function_mc_guid
MC Function: GUID

Format

Code Block
GUID( )

Returns Value

Returns the string type identifier for the indicated expression.

Examples

Expression	Result
GUID()	GFHGJ7FGHJ6FF555

Anchor
function_mc_gettypename
function_mc_gettypename
MC Function: GetTypeName

Format

Code Block
GetTypeName(expr)

Returns Value

Returns the string type identifier for the indicated expression.

Examples

Expression	Result
GetTypeName('1')	String
GetTypeName(123)	Long

Anchor
function_mc_if
function_mc_if
MC Function: If

Format

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

Arguments Types

object	String
decsep - decimal separator	String
thoussep - thousands separator	String

Return Type

Double

Returns Value

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

Examples

Expression

IF (Atoi(:tag10:)>0) THEN [nop();nop(); ] ELSE [nop(); nop();]

Anchor
function_mc_iif
function_mc_iif
MC Function: Iif

Format

Code Block
iif(logexpr, result_if_true, result_if_false)

Arguments Types

logexpr	Any type
result_if_false	Any type
result_if_true	Any type

Return Type

Any type can be returned

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

Expression

iif(Atoi(:tag10:)>0,nop(), nop())

Anchor
function_mc_isalpha
function_mc_isalpha
MC Function: IsAlpha

Format

Code Block
isAlpha(object_to_test)

Arguments Types

object_to_test

String

Return Type

Integer

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

Expression	Result
IsAlpha('abc')	1
IsAlpha('123')	0
IsAlpha('a2bc')	0

Anchor
function_mc_isalphanumeric
function_mc_isalphanumeric
MC Function: IsAlphaNumeric

Format

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

Arguments Types

object_to_test	String
separator	String

Return Type

Integer

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

Expression	Result
IsAlphaNumeric('abc')	1
IsAlphaNumeric('123')	1
IsAlphaNumeric('a2bc')	1

Anchor
function_mc_isdefined
function_mc_isdefined
MC Function: IsDefined

Format

Code Block
isDefined(varName)

Arguments Types

varName

String/Integer/Long

Return Type

Integer

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

Code Block
isNull(object)

Arguments Types

object

Any type

Return Type

Integer

Returns Value

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

Examples

Expression

IsNull(:var:)=1 if :var: has not been initialized anywhere before

IsNull(1)=0 as number 1 is not Null

Anchor
function_mc_isnumeric
function_mc_isnumeric
MC Function: IsNumeric

Format

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

Arguments Types

object	String
separator	String

Return Type

Integer

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

Expression	Result
IsNumeric('123')	1
IsNumeric(345)	1
IsNumeric('a')	0
IsNumeric(a)	error

Anchor
function_mc_left
function_mc_left
MC Function: Left

Format

Code Block
LEFT(left_object, left_howMuch)

Arguments Types

left_object	String
left_howMuch	Integer

Return Type

String

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

Expression	Result
LEFT('abcde',3)	'abc'

Anchor
function_mc_lower
function_mc_lower
MC Function: Lower

Format

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

Arguments Types

object	String
startPos	Integer
howMuch	Integer

Return Type

String

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

Expression	Result
Lower('ABCDE')	'abcde'
Lower('ABCDE',2)	'ABcde'
Lower('ABCDE',2,1)	'ABcDE'

Anchor
function_mc_makenumber
function_mc_makenumber
MC Function: MakeNumber

Format

Code Block
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

Code Block
Mid( midObject, midStart, midHowMuch )

Return Type

String

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

Code Block
NoOfLines( expr )

Return Type

Integer

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

Code Block
Nop()

Return Type

Void

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

Expression	Result
iif(isDefined(15), nop(), createVariable(15, "Value"))	In this example, Variable 15 is created only when it does not exist. If Variable 15 did not exist, this expression is somewhat slower than createVariable(15, "Value") If Variable 15 did exist, this expression is much faster than createVariable(15, "Value").

Anchor
function_mc_padleft
function_mc_padleft
MC Function: PadLeft

Format

Code Block
PadLeft( padObject, padChar, padMaxLen )

Return Type

String

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

Code Block
PadRight( padObject, padChar, padMaxLen )

Return Type

String

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

Code Block
RemoveMethod( name )

Arguments Types

name

String

Return Type

Integer

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

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

Arguments Types

object	String
what	String
with	String
from	Integer
howMuch	Integer

Return Type

String

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

Code Block
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

Code Block
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

Code Block
SetMethod( name, code )

Return Type

Integer

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

Code Block
StringLength( expr )

Return Type

Integer

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

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

Arguments Types

object	String
start	Integer
howMuch	Integer

Return Type

String

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

Code Block
Time( object, format )

Arguments Types

object	String
format	String

Return Type

Time

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

Code Block
Today()

Return Type

Date

Returns Value

Returns the current day value of type Date.

Anchor
function_mc_trim
function_mc_trim
MC Function: Trim

Format

Code Block
Trim( object )

Arguments Types

object

String

Return Type

String

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

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

Arguments Types

object	String
startPos	Integer
howMuch	Integer

Return Type

String

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

EBS-Specific Functions

Anchor
function_

xslt

ebs_

addifnotnullfunction_xslt_addifnotnullXSLT Function: AddIfNotNull

Format

Code Block
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

Expression

AddIfNotNull;

userField1

Anchorfunction_xslt_booleanfunction_xslt_booleanXSLT Function: Boolean

Format

Code Block
boolean( object )

Arguments Types

object

Alias or strings or number

Return Type

boolean

Returns Value

Returns the boolean representation of the object argument.

Examples

Expression

boolean( 1 )

Anchorfunction_xslt_ceilingfunction_xslt_ceilingXSLT Function: Ceiling

Format

Code Block
Ceiling( number )

Arguments Types

number

Return Type

number

Returns Value

Returns the smallest integer value not less than the argument.

Examples

Expression

ceiling( 5.6 )

Anchorfunction_xslt_concatfunction_xslt_concatXSLT Function: Concat

Format

Code Block
Concat( string, string, string* )

Arguments Types

string

alias and/or string

Return Type

string

Returns Value

Returns the concatenation of its arguments.

Examples

Expression
concat(	ITEM	, \"str\", \"	ITEM2	\|

Anchorfunction_xslt_containsfunction_xslt_containsXSLT Function: Contains

Format

Code Block
Contains( string, string )

Arguments Types

string

Alias and/or string

Return Type

boolean

Returns Value

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

Examples

Expression

contains(

ITEM

, \"str\" )

Anchorfunction_xslt_convertdatefunction_xslt_convertdateXSLT Function: ConvertDate

Format

Code Block
ConvertDate( date, inFormat, outFormat )

Arguments Types

date

string or Alias

inFormat

special string (\"M?/D?/YYYY h?:m?:s?\")

outFormat

special string (\"YYYY-MM-DD\")

Return Type

string

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

Expression

ConvertDate( \"8/8/2012\", \"M?/D?/YYYY h?:m?:s?\", \"YYYY-MM-DD\" )
ConvertDate(

ALIAS_DATE

, \"M?/D?/YYYY h?:m?:s?\", \"YYYY-MM-DD\" )
ConvertDate( \"8/8/2012 2:30:45\", \"M?/D?/YYYY h?:m?:s?\", \"YYYY-MM-DD\" )

Anchorfunction_xslt_countfunction_xslt_countXSLT Function: Count

Format

Code Block
Count( node-set )

Arguments Types

node-set

Alias

Return Type

number

Returns Value

Returns the number of nodes in the node-set.

Examples

Expression

count(

ITEMS

)

Anchorfunction_xslt_describexsltvarfunction_xslt_describexsltvarXSLT Function: DescribeXSLTVar

Format

Code Block
DescribeXSLTVar( var )

Return Type

node-set

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

Expression

DescribeXSLTVar( :var: )

Anchorfunction_xslt_falsefunction_xslt_falseXSLT Function: False

Format

Code Block
False( )

Return Type

boolean

Returns Value

Returns a boolean with the value of false.

Examples

Expression

false( )

Anchorfunction_xslt_floorfunction_xslt_floorXSLT Function: Floor

Format

Code Block
Floor( number )

Arguments Types

number

Return Type

number

Returns Value

Returns the largest integer value not greater than the argument.

Examples

Expression

floor( 5.6 )

Anchorfunction_xslt_idfunction_xslt_idXSLT Function: Id

Format

Code Block
Id( object )

Arguments Types

object

string

Return Type

node-set

Returns Value

Returns the element specified by it's unique Id.

Examples

Expression

id( \"foo\" )

Anchorfunction_xslt_iffunction_xslt_ifXSLT Function: If..Then..Else

Format

Code Block
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

Expression
If(	XrefType	='CUSIP' ) Then	XrefID	;; If(	XrefType	='SEDOL' ) Then	XrefID2	;;Else ConstValueString;;

Anchorfunction_xslt_langfunction_xslt_langXSLT Function: Lang

Format

Code Block
Lang( string )

Arguments Types

string

Return Type

boolean

Returns Value

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

Examples

Expression

lang( \"Example\" )

Anchorfunction_xslt_lastfunction_xslt_lastXSLT Function: Last

Format

Code Block
Last()

Return Type

number

Returns Value

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

Examples

Expression

last()

Anchorfunction_xslt_local-namefunction_xslt_local-nameXSLT Function: Local-name

Format

Code Block
Local-name( node-set )

Arguments Types

node-set

Alias

Return Type

string

Returns Value

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

Examples

Expression

local-name(

ITEM

)

Anchorfunction_xslt_namefunction_xslt_nameXSLT Function: Name

Format

Code Block
Name( node-set )

Arguments Types

node-set

Alias

Return Type

string

Returns Value

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

Examples

Expression
name(	ITEM	)

Anchorfunction_xslt_namespace-urifunction_xslt_namespace-uriXSLT Function: Namespace-uri

Format

Code Block
Namespace-uri( node-set )

Arguments Types

node-set

Alias

Return Type

string

Returns Value

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

Examples

Expression

namespace-uri(

ITEM

)

Anchorfunction_xslt_normalize-spacefunction_xslt_normalize-spaceXSLT Function: Normalize-space

Format

Code Block
Normalize-space( string )

Arguments Types

string

Alias or string

Return Type

string

Returns Value

Returns a space normalized string specified by the argument.

Examples

Expression

normalize-space(

ITEM

)

Anchorfunction_xslt_notfunction_xslt_notXSLT Function: Not

Format

Code Block
Not( boolean )

Arguments Types

boolean

Return Type

boolean

Returns Value

Returns a boolean with the opposite value of its argument.

Examples

Expression

not(contains(

ITEM

, \"Example\") )

Anchorfunction_xslt_numberfunction_xslt_numberXSLT Function: Number

Format

Code Block
Number( object )

Arguments Types

object

Alias or strings or number

Return Type

number

Returns Value

Returns the number representation of the object argument.

Examples

Expression

number(

ITEM

)

Anchorfunction_xslt_positionfunction_xslt_positionXSLT Function: Position

Format

Code Block
Position()

Return Type

number

Returns Value

Returns the position of the current context node.

Examples

Expression

position()

Anchorfunction_xslt_roundfunction_xslt_roundXSLT Function: Round

Format

Code Block
Round( number )

Arguments Types

number

Return Type

number

Returns Value

Returns the integer value closest to the argument.

Examples

Expression

round( 5.6 )

Anchorfunction_xslt_starts-withfunction_xslt_starts-withXSLT Function: Starts-with

Format

Code Block
Starts-with( string, string )

Arguments Types

string

Alias and/or string

Return Type

boolean

Returns Value

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

Examples

Expression

starts-with(

ITEM

, \"str\" )

Anchorfunction_xslt_stringfunction_xslt_stringXSLT Function: String

Format

Code Block
String( object )

Arguments Types

object

Alias

Return Type

string

Returns Value

Returns the string representation of the object argument.

Examples

Expression
string(	ITEM	)

Anchorfunction_xslt_string-lengthfunction_xslt_string-lengthXSLT Function: String-length

Format

Code Block
String-length( string )

Arguments Types

string

Alias or string

Return Type

number

Returns Value

Returns the length of the string specified by the argument.

Examples

Expression

string-length(

ITEM

)

Anchorfunction_xslt_substringfunction_xslt_substringXSLT Function: Substring

Format

Code Block
Substring( string, number, number )

or

Code Block
Substring( string, number )

Arguments Types

Alias/string and numbers

Return Type

string

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

Expression

substring(

ITEM

, 5 )

substring( \"2012-05-08\", 1, 4 )

Anchorfunction_xslt_substring-afterfunction_xslt_substring-afterXSLT Function: Substring-after

Format

Code Block
Substring-after( string, string )

Arguments Types

string

Alias or/and string

Return Type

string

Returns Value

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

Examples

Expression

substring-after(

ITEM

, \"str\" )

Anchorfunction_xslt_substring-beforefunction_xslt_substring-beforeXSLT Function: Substring-before

Format

Code Block
Substring-before( string, string )

Arguments Types

string

Alias or/and string

Return Type

string

Returns Value

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

Examples

Expression

substring-before(

ITEM

, \"str\" )

Anchorfunction_xslt_sumfunction_xslt_sumXSLT Function: Sum

Format

Code Block
Sum( node-set )

Arguments Types

node-set

Alias

Return Type

number

Returns Value

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

Examples

Expression

sum(

ITEMS

)

Anchorfunction_xslt_translatefunction_xslt_translateXSLT Function: Translate

Format

Code Block
Translate( string, string, string )

Arguments Types

Alias or/and strings

Return Type

string

Returns Value

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

Examples

Expression

translate(

ITEM

, \"rep\",

ITEM2

)

Anchorfunction_xslt_truefunction_xslt_trueXSLT Function: True

Format

Code Block
True( )

Return Type

boolean

Returns Value

Returns a boolean with the value of true.

Examples

Expression

true(

get_instruction_param
function_ebs_get_instruction_param
EBS Function: get_instruction_param

Format

Code Block
String, get_instruction_param (param_name, instructions)

Parameter Types

param_name ( String )

instructions ( instructions )

Returns Value

Returns Control Message parameter value by its name (param_name) and Control Message instance ( instractions ). :GVAR_RTR: build-in variable should be used for translation RTR.
If not found, empty string is returned.

Examples

Code Block

language	py

get_instruction_param ( ‘effectivedate’, :GVAR_RTR: )

Anchor
function_ebs_max
function_ebs_max
EBS Function: Max

Format

Code Block
Max( value[,condition[,defaultValue)]])

Arguments Types

object value
bool condition
object defaultValue

Returns Value

Return the maximum value of all from the first to current record in the group.
Record for which condition is not met will not be taken into account if the condition is set
Automatic cast to numeric type doesn’t occur

Examples

Code Block

language	text

Max(|VALUE|,|VALUE|>=0)

Anchor
function_ebs_min
function_ebs_min
EBS Function: Min

Format

Code Block
Min( value[,condition[,defaultValue)]])

Arguments Types

object value
bool condition
object defaultValue

Returns Value

Return the minimum value of all from the first to current record in the group.
Record for which condition is not met will not be taken into account if the condition is set
Automatic cast to numeric type doesn’t occur

Examples

Code Block

language	text

Min(|VALUE|,|VALUE|>=0)

Page Comparison

Versions Compared

Old Version 7

New Version 8

Key

Navigate the page:

Supported Message Center (MC) Functions

Anchorfunction_mc_atoffunction_mc_atofMC Function: Atof

Format

Arguments Types

Return Type

Returns Value

Examples

Anchorfunction_mc_atoifunction_mc_atoiMC Function: Atoi

Format

Arguments Types

Return Type

Returns Value

Examples

Anchorfunction_mc_atolfunction_mc_atolMC Function: Atol

Format

Arguments Types

Return Type

Returns Value

Examples

Anchorfunction_mc_convertfunction_mc_convertMC Function: Convert

Format

Arguments Types

Return Type

Returns Value

Examples

Anchorfunction_mc_countstringsfunction_mc_countstringsMC Function: CountStrings

Format

Returns Value

Examples

Anchorfunction_mc_createvariablefunction_mc_createvariableMC Function: CreateVariable

Format

Returns Value

Examples

Anchorfunction_mc_currenttimefunction_mc_currenttimeMC Function: CurrentTime

Format

Return Type

Returns Value

Examples

Anchorfunction_mc_datefunction_mc_dateMC Function: Date

Format

Arguments Types

Return Type

Returns Value

Anchorfucntion_mc_dayofweekfucntion_mc_dayofweekMC Function: DayOfWeek/DayOfWeekNr/DayOfWeekShrt

Format

Arguments Types

Return Type

Returns Value

Anchorfunction_mc_executemethodfunction_mc_executemethodMC Function: ExecuteMethod

Format

Arguments Types

Return Type

Returns Value

Examples

Anchorfunction_mc_findfunction_mc_findMC Function: Find

Format

Arguments Types

Return Type

Returns Value

Examples

Anchorfunction_mc_getdayfunction_mc_getdayMC Function: GetDay/GetMonth/GetYear

Format

Arguments Types

Return Type

Returns Value

Anchorfunction_mc_getdirrootfunction_mc_getdirrootMC Function: GetDirRoot

Format

Return Type

Returns Value

Anchorfunction_mc_getlinefunction_mc_getlineMC Function: GetLine

Format

Arguments Types

Return Type

Returns Value

Anchor
function_mc_atof
function_mc_atof
MC Function: Atof

Anchor
function_mc_atoi
function_mc_atoi
MC Function: Atoi

Anchor
function_mc_atol
function_mc_atol
MC Function: Atol

Anchor
function_mc_convert
function_mc_convert
MC Function: Convert

Anchor
function_mc_countstrings
function_mc_countstrings
MC Function: CountStrings

Anchor
function_mc_createvariable
function_mc_createvariable
MC Function: CreateVariable

Anchor
function_mc_currenttime
function_mc_currenttime
MC Function: CurrentTime

Anchor
function_mc_date
function_mc_date
MC Function: Date

Anchor
fucntion_mc_dayofweek
fucntion_mc_dayofweek
MC Function: DayOfWeek/DayOfWeekNr/DayOfWeekShrt

Anchor
function_mc_executemethod
function_mc_executemethod
MC Function: ExecuteMethod

Anchor
function_mc_find
function_mc_find
MC Function: Find

Anchor
function_mc_getday
function_mc_getday
MC Function: GetDay/GetMonth/GetYear

Anchor
function_mc_getdirroot
function_mc_getdirroot
MC Function: GetDirRoot

Anchor
function_mc_getline
function_mc_getline
MC Function: GetLine

Anchor
function_mc_getlines
function_mc_getlines
MC Function: GetLines

Anchor
function_mc_getplatform
function_mc_getplatform
MC Function: GetPlatform

Anchor
function_mc_guid
function_mc_guid
MC Function: GUID

Anchor
function_mc_gettypename
function_mc_gettypename
MC Function: GetTypeName

Anchor
function_mc_if
function_mc_if
MC Function: If

Anchor
function_mc_iif
function_mc_iif
MC Function: Iif

Anchor
function_mc_isalpha
function_mc_isalpha
MC Function: IsAlpha

Anchor
function_mc_isalphanumeric
function_mc_isalphanumeric
MC Function: IsAlphaNumeric

Anchor
function_mc_isdefined
function_mc_isdefined
MC Function: IsDefined

Anchor
function_mc_isnull
function_mc_isnull
MC Function: IsNull

Anchor
function_mc_isnumeric
function_mc_isnumeric
MC Function: IsNumeric

Anchor
function_mc_left
function_mc_left
MC Function: Left

Anchor
function_mc_lower
function_mc_lower
MC Function: Lower