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.