DELET

Returns a string obtained by deleting a specified number of characters from a string.

Syntax

DELET(String, StartLocation, N)

String is the string from which to delete characters. StartLocation is the location in the string from which to start deleting characters (1 being the first character in the string). N is the number of characters to delete.

Examples

This example returns 'Aa':

DELET('Alea', 2, 2)

This example returns 'A':

DELET('IACTA', 1, 4)