Right returns the rightmost 'n' characters of a string expression.Mid returns the specified portion of a string expression.Left returns the leftmost “n” characters of a string expression.Uppercase letters and all other characters remain unchanged. Only lowercase letters in a string are affected. UCase converts characters in a string to uppercase.All lowercase letters and nonletter characters remain unchanged. Only uppercase letters within the string are converted. LCase converts all letters in a string to lowercase.Val converts a string to a numeric value.

Str converts a numeric expression to a string in a locale-independent manner (contrary to the CStr function).

s = 'This string has ''embedded'' quotes' This is not necessary for the ' character, which can be included in a string literal by simply doubling it, eg. This function is used to represent characters, such as the carriage return code ( Chr(13)), that cannot be written in the '' notation. Chr returns a string containing the character that is specified by the ASCII or Unicode value passed to the function.Asc returns the Unicode value of the first character of its string parameter.Some of the functions are explained briefly in the following: Apache OpenOffice Basic supports several runtime functions for string manipulation.

Openoffice calc substring