Character Functions
Function | Description | Examples |
|---|---|---|
aptStringConcat | Creates a comma-separated list of strings. The Oracle function, aptStringConcat with DISTINCT or UNIQUE, cannot be used to concatenate values in a method, even though the method will validate and save. When that method is used in a report template, it will fail. Use collectString in a method to get this functionality. | aptStringConcat (array_name) can be used to create a comma-separated list of arrays within an array family. |
collectString | Use this function in the Method Designer to concatenate distinct values. | SELECT rtd.collectString(SET(CAST(COLLECT (cast(client_id as varchar2(10))) AS stringListType)),', ') name from apt_v_job; |
CONCAT | Concatenates multiple character strings. | 'Storage' + 'HQ' = 'StorageHQ' |
INITCAP | Displays a string with the first letter of each word in uppercase. | 'daily backup schedule' becomes 'Daily Backup Schedule' |
LOWER | Displays a string with all letters of each word in lowercase. | 'DAILY BACKUP SCHEDULE' becomes 'daily backup schedule' |
LPAD | Pads the left of a string with the specified characters, up to the total string length. | Preface an alert message with a string of asterisks; for example, ****Warning |
LTRIM | Trims the specified character set from the left of a string. This is useful for removing redundant words, characters, or labels. When no string is supplied, it defaults to a single blank. | 'RAID5' and 'RAID6' would be trimmed to simply '5' and '6' |
REPLACE | Substitutes one character string for another character string; in addition, you can remove character strings. | Substituting 'HDS' for 'Hitachi' changes 'Hitachi array' to 'HDS array' |
RPAD | Pads the right of a string with the specified characters, up to the total string length. | Postfix text with a string of asterisks; for example, Error*** |
RTRIM | Trims the specified character set from the right of a string. This is useful for removing redundant words, characters, or labels. When no string is supplied, it defaults to a single blank. | 'RAID 5' and 'RAID 6' could be trimmed to simply 'RAID' |
SUBSTR | Extracts a portion of a character string. | Use this function to list the first three characters of policy names. |
TO_DATE | Converts a character string to a date. | to_date('10/09/13', 'DD/mm/YY') to_date('10-sep-13', 'DD-MON-YYYY') |
TRANSLATE | Makes several single-character substitutions; one-to-one substitution in one operation. | Use this function to replace all spaces with an underscore character. 'System Reference Guide' would become 'System_Reference_Guide' |
TRIM | Removes leading or trailing characters (or both) from a character string | Use this function to remove leading zeroes from object identifiers (00049 --> 49) |
UPPER | Changes all characters in a string to uppercase | 'veritas' becomes 'VERITAS'; 'Aptare' becomes 'APTARE' |