Syntax:

Del(string,start,length)

Parameters:

string: An Alpha string or an Alpha string expression.

start: The position of the first character to be deleted.

length: The number of characters to be deleted, beginning with position start and proceeding rightward.

Returns:

An Alpha string

Examples:

Del('ABCD',2,1) deletes the second letter of the string, and returns 'ACD'.

If X contains a character string of length greater than or equal to 2, the following expression removes either the first or second character, or leaves the string intact, according to the value that appears in column Y (negative, positive or zero).

IF (Y<0,Del(X,1,1),IF(Y>0,Del(X,2,1),X))

See also:

Ins, Fill, Rep

The Online and Rich Client Samples projects (program ST03 and RST03)