Salesforce

Del (Magic xpa 2.x)

« Go Back

Information

 
Created ByKnowledge Migration User
Approval Process StatusPublished
Objective
Description

Del (Magic xpa 2.x)

Deletes characters from an alpha string.

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)

Reference
Attachment 
Attachment