Function |
Description |
|---|---|
Returns the Unicode character value of a specified character |
|
Returns the Unicode string corresponding to the given number, or formats a string |
|
Returns the capitalized representation of a string |
|
Concatenates all given parameters into a single string |
|
Concatenates a delimited string with special null and empty value handling |
|
Returns the leftmost N characters from a string |
|
Returns the length of a string |
|
Returns a part of a string |
|
Finds the first position of a substring within a string |
|
Returns the input string in lowercase letters |
|
Fills the left side of a string up to a specified length |
|
Removes characters from the left side of the string |
|
Returns the given string repeated N times |
|
Replaces parts of a string |
|
Reverses a string |
|
Returns the rightmost N characters from a string |
|
Finds the last position of a substring within a string |
|
Fills the right side of a string up to a specified length |
|
Removes characters from the right side of the string |
|
Removes characters from both sides of the string |
|
Returns the input string in uppercase letters |
Returns unicode character value of a specified character.
number uAsc(value [, index])
An input string
Character position for reading ASCII value
uAsc("Big Ben") // returns 66
uAsc("Big Ben", 2) // returns 105
Returns the Unicode string corresponding to the given number, or formats a string
string uChr(params, ...)
A list of expressions or values
uChr(64) // returns "@"
uChr("\u0064\u006f\u0067") // returns "dog"
uChr(65,"pple") // returns "apple"
Returns the capitalized representation of a string. In other words, the first letter of each word in the string is capitalized.
string uCap(text)
The string to be capitalized
uCap('fArmeR, ASTROnaut') // returns 'Farmer, Astronaut'
uCap('the first weekend') // returns 'The First Weekend'
Concatenates all given parameters into a single string
string uConcat(params)
A list of expressions or values of any data type
uConcat("For ", 3, " years.") returns "For 3 years."
Concatenates a delimited string with special null and empty value handling
string uJoin(delimiter, allowEmpty, params, ...)
Delimiter to be used between all other string parts
Flag (0/1) that indicate whether empty fields are allowed
List of strings to concatenate
uJoin("-", 1, "James", "", "Tiberius", "Kirk") //
returns "James--Tiberius-Kirk"
uJoin("-", 0, "James", "", "Tiberius", "Kirk") //
returns "James-Tiberius-Kirk"
Returns the leftmost N characters from a string
string uLeft(input, chars)
The input string
The number of characters to be retrieved
uLeft("James T. Kirk", 5) // returns "James"
uLeft(null, 5) // returns null
Returns the length of a string
number uLength(input)
The input string
uLength("James T. Kirk") // returns 13
Returns a part of a string
string uSubstr(input, position, length)
Input string
The position from where to start reading
The number of characters to read
uSubstr("James T. Kirk", 7, 2) // returns "T."
Find the first position of a substring within a string. A result of zero indicates that the substring has not been found.
string uLPos(input, substring)
The input string
The substring to search
uLPos("James T. Kirk", "T") //returns 7
Returns the input string in lower case letters
string uLower(input)
The string to convert
uLower("James T. Kirk") // returns "james t. kirk"
Fills the left side of a string up to specified length
string uLStuff(input, length [, stuff])
The string to stuff
New length of string
String to append, default is an empty space (ASCII 32)
uLStuff("3.5", 5) // returns " 3.5"
uLStuff("3.5", 5, "0") // returns "003.5"
Removes characters from the left side of the string. If the second parameter is omitted, it defaults to a space character (ASCII 32).
string uLTrim(input, trimstring)
The string to be trimmed
The string to trim
uLTrim(" 3.5") // returns "3.5"
uLTrim("003.5", "0") // returns "3.5"
Returns the given string repeated N times
string uRepeat(input, repeats)
The string to be repeated
The number of times to repeat the input string
uRepeat("Hello ", 4) // returns "Hello Hello Hello Hello "
Replaces parts of a string
string uReplace(input, search, replace)
The string to be worked on
The pattern to be searched
The string to replace any match
uReplace("At four o' clock he became four", "four", "4")
// returns "At 4 o' clock he became 4"
Reverses a string
string uReverse(input)
The string to reverse
uReverse("Smith") // returns "htimS"
Returns the rightmost N characters from a string
string uRight(input, chars)
The input string
The number of characters to be read
uRight("James T. Kirk", 4) // returns "Kirk"
uRight(null, 5) / / returns null
Find the last position of a substring within a string
string uRPos(input, substring)
The input string
The substring to find
Find the last ocurrence of a substring:
uRPos("James T. Kirk", "T") //returns 7
Fills the right side of a string up to specified length
string uRStuff(input, length [, stuffstring])
The input string
The new length of the result string
The string to append
uRStuff("3.5", 5) // returns "3.5 "
uRStuff("3.5", 5, "0") // returns "3.500"
Removes characters from the right side of the string
string uRTrim(input [, trimstring])
The input string
The string to trim
uRTrim("3.5 ") // returns "3.5"
uRTrim("3.500", "0") // returns "3.5"
Removes characters from both sides of the string
string uTrim(input [, trimstring])
The input string
The string to trim
uTrim(" 3.5 ") // returns "3.5"
uTrim("003.500", "0") // returns "3.5"
Returns the input string in upper case letters
string uUpper(input)
The input string
uUpper("James T. Kirk") // returns "JAMES T. KIRK"
