String Handling

ALPHA( ): Determines whether the expression is an alphabetic or nonalphabetic string.
CATS( ): Concatenates elements of two dynamic arrays.
CHANGE( ): Substitutes an element of a string with a replacement element.
CHECKSUM( ): Returns a cyclical redundancy code (a checksum value).
COL1( ): Returns the column position immediately preceding the selected substring after a BASIC FIELD function is executed.
COL2( ): Returns the column position immediately following the selected substring after a BASIC FIELD function is executed.
COMPARE( ): Compares two strings for sorting.
CONVERT: Converts specified characters in a string to designated replacement characters.
CONVERT( ): Replaces every occurrence of specified characters in a variable with other specified characters.
COUNT( ): Evaluates the number of times a substring is repeated in a string.
CRC32( ): Returns a 32-bit cyclic redundancy code.
COUNTS( ): Evaluates the number of times a substring is repeated in each element of a dynamic array.
DCOUNT( ): Evaluates the number of delimited fields contained in a string.
DEL: Deletes the specified field, value, or subvalue from a dynamic array.
DELETE( ): Deletes a field, value, or subvalue from a dynamic array.
DOWNCASE( ): Converts all uppercase letters in an expression to lowercase.
DQUOTE( ): Encloses an expression in double quotation marks.
EREPLACE( ): Substitutes an element of a string with a replacement element.
EXCHANGE( ): Replaces one character with another or deletes all occurrences of a specific character.
EXTRACT( ): Extracts the contents of a specified field, value, or subvalue from a dynamic array.
FIELD( ): Examines a string expression for any occurrence of a specified delimiter and returns a substring that is marked by that delimiter.
FIELDS( ): Examines each element of a dynamic array for any occurrence of a specified delimiter and returns substrings that are marked by that delimiter.
FIELDSTORE( ): Replaces, deletes, or inserts substrings in a specified character string.
FIND: Locates a given occurrence of an element within a dynamic array.
FINDSTR: Locates a given occurrence of a substring.
FOLD( ): Divides a string into a number of shorter sections.
GETREM( ): Returns the numeric value for the position of the REMOVE pointer associated with a dynamic array.
GROUP( ): Returns a substring that is located between the stated number of occurrences of a delimiter.
GROUPSTORE: Modifies existing character strings by inserting, deleting, or replacing substrings that are separated by a delimiter character.
INDEX( ): Returns the starting column position of a specified occurrence of a particular substring within a string expression.
INDEXS( ): Returns the starting column position of a specified occurrence of a particular substring within each element of a dynamic array.
INS: Inserts a specified field, value, or subvalue into a dynamic array.
INSERT( ): Inserts a field, value, or subvalue into a dynamic array.
LEFT( ): Specifies a substring consisting of the first n characters of a string.
LEN( ): Calculates the length of a string.
LENS( ): Calculates the length of each element of a dynamic array.
LOCATE: Searches a dynamic array for a particular value or string, and returns the index of its position.
LOWER( ): Converts system delimiters that appear in expressions to the next lower-level delimiter.
MATBUILD: Builds a string by concatenating the elements of an array.
MATCHFIELD( ): Returns the contents of a substring that matches a specified pattern or part of a pattern.
MATPARSE: Assigns the elements of an array from the elements of a dynamic array.
QUOTE( ): Encloses an expression in double quotation marks.
RAISE( ): Converts system delimiters that appear in expressions to the next higher-level delimiter.
REMOVE statement: Removes substrings from a dynamic array.
REMOVE function: Successively removes elements from a dynamic array. Extracts successive fields, values, and so on, for dynamic array processing.
REVREMOVE statement: Successively removes elements from a dynamic array, starting from the last element and moving right to left. Extracts successive fields, values, and so on, for dynamic array processing.
REPLACE( ): Replaces all or part of the contents of a dynamic array.
REUSE( ): Reuses the last value in the shorter of two multi-value lists in a dynamic array operation.
RIGHT ( ): Specifies a substring consisting of the last n characters of a string.
SETREM: Sets the position of the REMOVE pointer associated with a dynamic array.
SOUNDEX( ): Returns the soundex code for a string.
SPACE( ): Generates a string consisting of a specified number of blank spaces.
SPACES( ): Generates a dynamic array consisting of a specified number of blank spaces for each element.
SPLICE( ): Inserts a string between the concatenated values of corresponding elements of two dynamic arrays.
SQUOTE( ): Encloses an expression in single quotation marks.
STR( ): Generates a particular character string a specified number of times.
STRS( ): Generates a dynamic array whose elements consist of a character string repeated a specified number of times.
SUBSTRINGS( ): Creates a dynamic array consisting of substrings of the elements of another dynamic array.
TRIM( ): Deletes extra blank spaces and tabs from a character string.
TRIMB( ): Deletes all blank spaces and tabs after the last non-blank character in an expression.
TRIMBS( ): Deletes all trailing blank spaces and tabs from each element of a dynamic array.
TRIMF( ): Deletes all blank spaces and tabs up to the first nonblank character in an expression.
TRIMFS( ): Deletes all leading blank spaces and tabs from each element of a dynamic array.
TRIMS( ): Deletes extra blank spaces and tabs from the elements of a dynamic array.
UPCASE( ): Converts all lowercase letters in an expression to uppercase.