remove leading and/or trailing characters(a,b,c)

Group

Basic Functions


This function can be used to remove a leading and trailing character sequence b from string a.

Parameter Description


Parameter

Description

a

The string to be processed.

b

The character sequence to be removed.

c

The processing mode. Allowed values: leading, trailing, both.

Examples


Parameter a

Parameter b

Parameter c

Result

aaXXXaaa

a

leading

XXXaaa

baaXXXaaa

a

leading

baaXXXaaa

aaXXXaaa

a

trailing

aaXXX

aaXXXaaa

a

both

XXX