Function Description
Trim-Leading Returns a string with leading spaces removed.
Trim-Trailing Returns a string with trailing spaces removed.
Upper Converts lowercase characters to uppercase.
Note: The Pack, Spread and Substitute text functions are not supported in Cognos
Transformer version 8.x and later.
Char_Length
Returns the number of characters in a string.
Syntax
char_length (string_exp)
Examples
char_length (’ABCDEFG’)
Returns the result: 7
char_length (’’)
Returns the result: 0
char_length (’ ’)
Returns the result: 1
First-Word
Returns the first word in a string.
Syntax
first-word (string_exp)
Example
first-word (’Cat sat on the mat’)
Returns the result: Cat
Left
Returns a specific number of characters, starting at the left of the string.
Syntax
left (string_exp, integer_exp)
Example
left (’ABCDEFG’, 2)
Returns the result: AB
Lower
Converts uppercase characters to lowercase.
368 IBM Cognos Transformer Version 10.1.1: User Guide
To Next Page
Loading...
Need help?
General