Copy

Returns a substring of a string or a segment of a dynamic array.

Syntax

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

Description

S is an expression of a string or dynamic-array type. Index and Count are integer-type expressions. Copy returns a substring or sub array containing Count characters or elements starting at S[Index].
If Index is larger than the length of S, Copy returns an empty string or array.
If Count specifies more characters or array elements than are available, only the characters or elements from S[Index] to the end of S are returned.

Example

Copy('Demo DB',2,4),Return value is 'mo D'

 

 

 

Return to DBPut data converter document

Download DBPut data converter software