remove leading and/or trailing characters()

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

Parameters


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