call-for-papers

The following is a list of text functions.

Function Description

BCDTOTEXT Converts the digits in a BCD item to a text item containing the digits as a string of characters.

COUNTSTRING Returns an integer representing the number of times that a specified character string appears in a given character string.

DATETOTEXT Converts a date object or expression to a text item.

FILLLEFT Returns a text item of the specified length. The output is right justified and the output is filled on its left with the specified pad value.

FILLRIGHT Returns a text item of the specified length. The output is left justified and the output is filled on its right with the specified pad value.

FIND Returns the position in a text string at which another specified text string begins.

HEXTEXTTOSTREAM Returns a binary text stream whose value is the evaluation of input character text represented by hex pairs.

ISALPHA Tests a text object to see whether it is contains all alphabetic characters.

ISLOWER Tests a text object to see whether it is contains all lowercase alphabetic characters.

ISNUMBER Tests a text object to see whether it is a number.

ISUPPER Tests a text object to see whether it is contains all uppercase alphabetic characters.

LEAVEALPHA Removes characters that are not alphabetic from a specified text item.

LEAVEALPHANUM Removes characters that are not alphabetic or numeric from a specified text item.

LEAVENUM Removes non-numeric characters from a text item.

LEAVEPRINT Removes non-printable characters from a text item.

LEFT Returns a specified number of characters from a text item, starting with the leftmost character.

LOWERCASE Converts a text item to lowercase characters.

MAX Returns the maximum value from a series of number, date, time, or text values.

MID Extracts a specified number of characters from a text item, starting at a specified position.

MIN Returns the minimum value from a series of number, date, time, or text values.

NUMBERTOTEXT Converts a number to text that looks like the original object.

OFFSET Returns an integer representing the offset of the specified object within the data, beginning at offset 0.

PACKAGE Converts a group or item object to a text item, including its initiator and terminator.

PROPERCASE Converts each "word" in a string, such that the first alphabetic character is uppercase and the remaining alphabetic characters are lowercase.

REVERSEBYTE Reverses the byte order of an item.

RIGHT Extracts a specified number of characters of a text item, starting with the rightmost character.

SERIESTOTEXT Converts a contiguous or non-contiguous series to a text item.

SIZE Returns, as an integer, the size of an object, exclusive of any pad characters.

SQUEEZE Removes consecutive duplicates of a specified character from a text item.

STREAMTOHEXTEXT Returns a character text string represented by hex pairs whose value is the evaluation of input binary text.

SUBSTITUTE Replaces specified text with other specified text in a text item.

TEXT Converts a group or item object to a text item.

TEXTTOBCD Converts a text item from decimal digits to Binary Coded Decimal (BCD) format.

TEXTTODATE Converts text that is in CCYYMMDD or YYMMDD presentation to a date that looks like the text item.

TEXTTONUMBER Converts an object defined as text to an object defined as a character number item.

TEXTTOTIME Converts an object defined as text to an object defined as time.

TIMETOTEXT Converts a time object or expression to a text item.

TODATETIME Converts a text string of a specified format to a date/time.

TONUMBER Converts a text string of a specified format to a number.

TRIMLEFT Removes leading spaces (or another specified character) from a text item.

TRIMRIGHT Removes trailing spaces (or another specified character) from a text item.

UPPERCASE Converts text to uppercase characters.

WORD Returns the characters between two user-defined separators within a delimited text item.