String Extension Functions tool palette
| Name | Description |
|---|---|
| apply default | Returns a default value when the input string is empty or missing. |
| compare | Compares two strings lexicographically. |
| compare ignore case | Compares two strings lexicographically, ignoring case. |
| delete | Removes the characters in the input string, using a start and end position. |
| delete all | Removes all occurrences of the substring argument from the input string. |
| delete char at | Removes the character at the specified position in the input string. |
| delete first | Removes the first occurrence of the specified substring. |
| delete last | Removes the last occurrence of the specified substring. |
| ends with | Tests if the input string ends with the specified suffix. |
| equals | Tests if the two input strings are equal. |
| equals ignore case | Tests if the two input strings are equal, ignoring case. |
| get field | Extracts and returns the field within the delimited input string at the specified index. |
| get field count | Returns the count fields within the delimited input string. |
| index of | Returns the index into the first input string of the first occurrence of the second output string. |
| index of from start position | Returns the index into the first input string of the first occurrence of the second input string starting at the specified position. |
| insert | Returns the first input string with the second input string inserted at the specified position. |
| justify center | Returns the input string center-justified and padded to the left and right with the specified pad string. |
| justify center to length | Returns the input string center-justified and padded to the left and right with the specified pad string, maximized to the specified length. |
| justify left | Returns the input string left-justified and padded to the right with the specified pad string. |
| justify left to length | Returns the input string left-justified and padded to the right with the specified pad string, maximized to the specified length. |
| justify right | Returns the input string right-justified and padded to the left with the specified pad string. |
| justify right to length | Returns the input string right-justified and padded to the left with the specified pad string, maximized to the specified length |
| last index of | Returns the index into the first input string of the last occurrence of the second input string. |
| last index of from start position | Returns the index into the first input string of the last occurrence of the second input string starting at the specified position. |
| matches | Tests whether or not the input string matches the specified regular expression. |
| prefix | Returns the input string with the specified prefix added to the beginning. |
| region matches | Tests if two string regions are equal. |
| region matches ignore case | Tests if two string regions are equal, ignoring case if the IgnoreCase argument is true. |
| replace | Replaces the input string with the specified replacement, using a start and end position. |
| replace all | Replaces each of the specified substrings of the input string with the specified replacement. |
| replace all regex | Replaces each of the specified regular expressions of the input string with the specified replacement. |
| replace first | Replaces the first substring of the input string with the specified replacement. |
| replace first regex | Replaces the first specified regular expression of the input string with the specified replacement. |
| starts with from start position | Tests if the input string starts with a specified prefix, using a starting position. |
| substitute | Matches the input string against a list of strings. If there is a match, the corresponding string substitution is made. |
| substring | Returns a substring of the input string, starting at a specified position for a specified length. |
| substring-to-end | Returns a substring of the input string, starting at a specified position for the remaining length of the string. |
| substring-after | Returns a substring of the input string, starting after the first occurrence of the specified substring for the remaining length of the string. |
| substring-before | Returns a substring of the input string, ending at the start of the first occurrence of the specified substring. |
| suffix | Returns the substring with the specified suffix added to the end. |
| to hex string | Returns the input string in a hex-encoded form. |
| to lower | Returns the input string with all characters converted to lowercase. |
| to upper | Returns the input string with all characters converted to uppercase. |
| trip | Returns the input string with leading and trailing occurrences of the specified trim string removed. |
| trim left | Returns the input string with leading occurrences of the specified trim string removed. |
| trim right | Returns the input string with trailing occurrences of the specified trim string removed. |
Supported Transformation Functions
XPath Node Set Functions Tool Palette
Conditional Logic Functions Tool Palette
Send your feedback on this help topic to Sybase Tech Pubs: pubs@sybase.com