DEL

DEL();

Deletes a specific character (or string of characters) in the beginning of a field.

 

Example 1:

##DEL("Name", 'Mr.') will delete 'Mr.' from the field.

If "Name" has the value "Mr. Peter Petersen" it will return the result "Peter Petersen".

 

Example 2:

##DEL("Name", 'x') will delete all occurrences of 'x' at the beginning of the field.

If "Name" has the value "xxxxxxPeter Petersen" it will return the result "Peter Petersen".

 

Example 3:

##DEL("Name", ' ') will delete all occurrences of ' ' at the beginning of the field.

If "Name" has the value "      Peter Petersen" it will return the result "Peter Petersen".

 

NOTICE THAT:

The DEL function only operates at the beginning of a field, and characters are case sensitive.