String Manipulation

Command

Description

[n,m]

Extracts or assigns m characters starting at column n from or to a string.

Char()

Returns the ASCII character string value of an expression.

Col1(), Col2()

Returns the column positions of delimiters used by the Field and Bracket ([ ]) commands.

Convert statement

Converts a set of characters in a string into a different set of character.

Count()

Counts repetitions of a particular character (or string of characters) in a string.

Delete()

Use to delete elements from a dynamic array. Data can be deleted from field, value, and subvalue positions.

Field()

Returns successive fields which precede a defined delimiter.

FieldStore()

Used to replace, delete, or insert substrings in a string.

Index()

Returns starting column location of a designated occurrence of a sub-string.

Insert()

Used to insert a field, value, or subvalue into a character string dynamic array.

Len()

Returns length of a specified string.

Locate statement

Locates the position of a field, value, or sub-value in a string, returns the value of that position. By clause is used for locating a position where an item should be inserted.

MatParse statement

Turns a dynamic array into a dimensioned array.

MatUnparse()

Turns a dimensioned array into a dynamic array.

Seq()

Returns the ASCII sequence of a character.

Swap statement

Exchanges all occurrences of one sub-string in a string for another.

Trim(),TrimB(), TrimF()

Deletes extra blank spaces from a character string or variable. TrimB() deletes blank spaces at the end of a character string. TrimF() deletes spaces from the from of a character string.