Open Group CLI String Functions
From Apache OpenOffice Wiki
< Documentation | DevGuide
String Functions | Function Returns |
---|---|
ASCII(string)
|
Integer representing the ASCII code value of the leftmost character in string. |
CHAR(code)
|
Character with ASCII code value code, where the code is between 0 and 255. |
CONCAT(string1, string2)
|
Character string formed by appending string2 to string1. If a string is null, the result is DBMS-dependent. |
DIFFERENCE(string1, string2)
|
Integer indicating the difference between the values returned by the function SOUNDEX for string1 and string2. |
INSERT(string1, start, length, string2)
|
A character string formed by deleting length characters from string1 beginning at the start, and inserting string2 into string1 at the start. |
LCASE(string)
|
Converts all uppercase characters in string to lowercase. |
LEFT(string, count)
|
The count leftmost characters from string. |
LENGTH(string)
|
Number of characters in string, excluding trailing blanks. |
LOCATE(string1, string2[, start])
|
Position in string2 of the first occurrence of string1, searching from the beginning of string2. If start is specified, the search begins from position start. A 0 is returned if string2 does not contain string1. Position 1 is the first character in string2. |
LTRIM(string)
|
Characters of string with leading blank spaces removed. |
REPEAT(string, count)
|
A character string formed by repeating string count times. |
REPLACE(string1, string2, string3)
|
Replaces all occurrences of string2 in string1 with string3. |
RIGHT(string, count)
|
The count rightmost characters in string. |
RTRIM(string)
|
The characters of string with no trailing blanks. |
SOUNDEX(string)
|
A character string that is data source-dependent, representing the sound of the words in string, such as a four-digit SOUNDEX code, or a phonetic representation of each word. |
SPACE(count)
|
A character string consisting of count spaces. |
SUBSTRING(string, start, length)
|
A character string formed by extracting length characters from string beginning at start. |
UCASE(string)
|
Converts all lowercase characters in string to uppercase. |
Content on this page is licensed under the Public Documentation License (PDL). |