User`s guide

uLStuff
182 Sybase IQ ETL 4.1
uLStuff
Description Fills the left side of a string up to a specified length. By default, the string is
stuffed with spaces (ASCII 32).
Syntax string uLStuff(input, length, [ stuff)
Parameters
string input
The input string.
number length
New length of string.
string stuff(optional)
String to append, default is an empty space (ASCII 32).
Examples To expand a string by filling its left side:
uLStuff(“3.5”, 5) // returns “ 3.5”
uLStuff(“3.5”, 5, 5, “0”) // returns “0003.5”
uLTrim
Description Removes characters from the left side of the string. If the second parameter is
omitted, it defaults to space (ASCII 32).
Syntax string uLTrim(input, trimstring)
Parameters
string input
The input string.
string trimstring
The string to trim.
Examples To trim a string on the left side:
uLTrim(" 3.5") // returns "3.5"
uLTrim("003.5", "0") // returns "3.5"
uRepeat
Description Returns the given string repeated N times.