substring( a, start [,length] )

Returns a substring of text a starting at position b with a length of c.

Description of Parameters


Parameter

Description

a

Text.

b

Start position (index begins at 1).

c

(optional) Length. Full length of text a if empty.


Examples


Parameter a

Parameter b

Parameter c

Result

abcdef

4

3

def

abcdef

4

1

d

abcdef

1


abcdef