Text

Text functions let you perform a variety of different tasks with character data.

For example, you can remove leading or trailing spaces, exclude or include specific characters, isolate just a portion of a character string, or standardize upper or lowercase.

Function descriptions

Function	Description
ALLTRIM( )	Returns a string with leading and trailing spaces removed from the input string.
BINTOSTR( )	Returns Unicode character data converted from ZONED or EBCDIC character data. Abbreviation for "Binary to String".
BLANKS( )	Returns a string containing a specified number of blank spaces.
DATETIME( )	Converts a datetime to a character string. Can also return the current operating system datetime.
DTOU( )	Converts an Analytics date value to a Unicode string in the specified language and locale format. Abbreviation for "Date to Unicode".
EBCDIC( )	Returns a string that has been converted to EBCDIC character encoding.
EXCLUDE( )	Returns a string that excludes the specified characters.
INCLUDE( )	Returns a string that includes only the specified characters.
INSERT( )	Returns the original string with specified text inserted at a specific byte location.
LAST( )	Returns a specified number of characters from the end of a string.
LENGTH( )	Returns the number of characters in a string.
LOWER( )	Returns a string with alphabetic characters converted to lowercase.
LTRIM( )	Returns a string with leading spaces removed from the input string.
OMIT( )	Returns a string with one or more specified substrings removed.
PROPER( )	Returns a string with the first character of each word set to uppercase and the remaining characters set to lowercase.
REMOVE( )	Returns a string that includes only the specified characters.
REPEAT( )	Returns a string that repeats a substring a specified number of times.
REVERSE( )	Returns a string with the characters in reverse order.
RJUSTIFY( )	Returns a right-justified string the same length as a specified string, with any trailing spaces moved to the left of the string.
SPLIT( )	Returns a specified segment from a string.
STRING( )	Converts a numeric value to a character string.
SUBSTR( )	Returns a specified substring from a string.
TRANSFORM( )	Reverses the display order of bi-directional text within a specified string.
TRIM( )	Returns a string with trailing spaces removed from the input string.
UPPER( )	Returns a string with alphabetic characters converted to uppercase.
ZONED( )	Converts numeric data to character data and adds leading zeros to the output.

[ Back to top ]

ACL Scripting Guide 14.1