User`s guide

uRight
184 Sybase IQ ETL 4.1
uRight
Description Returns the rightmost N characters from a string.
Syntax string uRight(input, chars)
Parameters
string input
The input string.
number chars
The number of chars to be read.
Examples To get the rightmost part of a string:
uRight("James T. Kirk", 4) // returns "Kirk"
uRight(null, 5) / / returns null
uRPos
Description Returns the position of a substring within a string. A result of zero indicates
that the substring has not been found.
Syntax string uRPos(input, substring)
Parameters
string input
The input string.
string substring
The substring to find.
Examples To find the last occurrence of a substring:
uRPos("James T. Kirk", "T") //returns 7
uRStuff
Description Fills the right side of a string up to specified length. By default, the string is
stuffed with spaces (ASCII 32).
Syntax string uRStuff(input, length, stuffstring)
Parameters
string input
The input string.