User`s guide

uLeft
180 Sybase IQ ETL 4.1
returns "James-Tiberius-Kirk"
uLeft
Description Returns the leftmost N characters from a string
Syntax string uLeft(input, chars)
Parameters
string input
The input string.
number chars
The amount of characters to be retrieved.
Examples To get the leftmost part of a string:
uLeft("James T. Kirk", 5) // returns "James"
uLeft(null, 5) // returns null
uLength, uLen
Description Returns the length of a string
Syntax String uLength(input)
Parameters
string input
The input string.
Examples To get the length of a string:
uLength("James T. Kirk") // returns 13
uSubstr, uMid
Description Returns a part of a string starting at a character position with a length of length.
Syntax string uSubstr(input, position, length)
Parameters
string input
The input string.