Delete

Removes a substring from a string.

Syntax

Delete(S, Index, Count)
Parameters of Delete:
S:Necessary parameter.Character string type.
Index:Necessary parameter.Integer type.
Count:Necessary parameter.Integer type.

Description

If index is larger than the length of the S or less than 1, no characters are deleted.
If count specifies more characters than remain starting at the index, Delete removes the rest of the string. If count is less than 0, no characters are deleted.

Example

Delete('Demo DB',2,4),return value is ' DeB'.

 

 

 

Return to DBPut data converter document

Download DBPut data converter software