Syntax
lower (string_exp)
Example
lower (’ABCDEFG’)
Returns the result: abcdefg
Position
Returns the starting position of string_exp1 in string_exp2. The first character in a
string is at position one.
Syntax
position (string_exp1, string_exp2)
Examples
position (’DEF’, ’ABCDEF’)
Returns the result: 4
position (’Z’, ’ABCDEFGH’
Returns the result: 0
Reverse
Reverses the characters in a string.
Syntax
reverse (string_exp)
Example
reverse (’ABCDEF’)
Returns the result: FEDCBA
Right
Returns a specific number of characters, starting at the right of the string.
Syntax
right (string_exp, integer_exp)
Example
right (’ABCDEFG’, 3)
Returns the result: EFG
String-to-Integer
Returns the integer representation of string_exp.
Syntax
string-to-integer (string_exp)
Appendix F. IBM Cognos Transformer Expression Editor 369
To Next Page
Loading...
Need help?
General