User`s guide
uChr, uUniChr
178 Sybase IQ ETL 4.1
Parameters
string value
An input string.
number index
Character position for reading ASCII value.
Examples To get a Unicode value from a string:
uAsc("Big Ben") // returns 66
uAsc("Big Ben", 2) // returns 105
uChr, uUniChr
Description Similar to the common chr function but returns the Unicode character specified
by the number given. In addition you can also specify more than one character
and unicode escape sequences in order to create a string.
Syntax string uChr(params, ...)
Parameters
params
A list of expressions or values.
Examples To create a Unicode string from char values:
What you will see:
uChr(64) // returns "@"
uChr("\u0064\u006f\u0067") // returns "dog"
uChr(65, "pple ") // returns "apple"
uCap
Description Returns the capitalized representation of a string. In other words, the first letter
of each and every word in the string is capitalized.
Syntax string uCap(text )
Parameters
input text
The string to be capitalized.
Examples To capitalize a string: