SUBSTR is supported for Oracle compatibility. Use SUBSTRING to extract a substring from stream data. If string-expression is a stream field, SUBSTR generates an SQLCODE -37. If either start or length is NULL, NULL is returned. Throws: IndexOutOfBoundsException - if the beginIndex is negative, or endIndex is. If length is less that 1, NULL is returned. If length larger than the remaining characters in the string, the substring from start to the end of the string is returned. If start is past the end of the string, NULL is returned. If the negative number is so large that its value counted backwards from the end of the string would position before the beginning of the string, the returned substring begins with the first character of the string. If start is a negative number the returned substring begins that number of characters from the end of the string, with -1 representing the last character of the string. If start is 0, –0, or 1, the returned substring begins with the first character of the string. If length is 0 or a negative number, InterSystems IRIS returns NULL.īecause start can be negative, you can obtain a substring from either the beginning or end of the original string.įloating-point numbers passed as arguments to SUBSTR are converted to integers by truncating the fractional portion. If omitted, substring goes from start to the end of string-expression. This value specifies that the substring ends length characters to the right of the starting position. Optional - A positive integer that specifies the length of the substring to return. If start is 0 (zero), it is treated as 1. A negative starting position specifies the number of characters from the end of the string.
The first character in string-expression1 is at position 1. A positive starting position specifies the number of characters from the beginning of the string. As an example, let’s say you wanted to get a substring from a string in Java with the.
The two parameters of the command define the beginning and end of the subsection you’d like to extract. The syntax for the command can be written as follows: stringName.substring (startingIndex, endingIndex). The expression can be the name of a column, a string literal, or the result of another scalar function, where the underlying data type can be represented as any character type (such as CHAR or VARCHAR).Īn integer that specifies where in string-expression the substring will begin. String Java substrings are fairly easy to use. The string expression from which the substring is to be derived.
0 kommentar(er)
