String Functions Tool Palette

String functions tool palette

IconNameDescription
concatenateconcatReturns the concatenation of its arguments.
containscontainsReturns true if the first argument string contains the second argument string. Otherwise, returns false.
normalize spacenormalize-spaceRemoves leading and trailing whitespace from a string and replaces internal sequences of whitespace with a single space character.
starts withstarts-withReturns true if the first argument string starts with the second argument string. Otherwise, returns false.
stringstringConverts and object to a string.
string lengthstring-lengthReturns the number of characters in a string value.
substringsubstringReturns the substring of the first argument starting at the position specified in the second argument with the length specified in the third argument. Example: substring('12345',2,3) returns '234'.
substring-to-endsubstring-to-endReturns the substring of the first argument starting at the position specified in the second argument and continues to the end of the string. Example: substring ('12345',2) returns '2345'.
substring-aftersubstring-afterReturns the substring of the first argument string that follows the first occurrence of the second argument string in the first argument string, or the empty string if the first argument string does not contain the second argument string. For example, substring-after('1999/04/01','/') returns 04/01, and substring-after('1999/04/01', 19) returns 99/04/01.
substring beforesubstring-beforeReturns the substring of the first argument string that precedes the first occurrence of the second argument string in the first argument string, or the empty string if the first argument string, or the empty string if the first argument string does not contain the second argument string. For example, substring-before('1999/04/01','/') returns 1999.
to lower caseto lower caseConverts the contents of a string to lower case.
to upper caseto upper caseConverts the contents of a string to upper case.
translatetranslateReturns the first argument string with occurrences of characters in the second argument string replaced by the character at the corresponding position in the third argument string.

Tool Palettes

Boolean Functions Tool Palette

Number Functions Tool Palette

Node Set Functions Tool Palette

Generic Variable and Constants Tool Palette

Send your feedback on this help topic to Sybase Tech Pubs: pubs@sybase.com