trim()

Function group	Execute on client	Platform(s)
String	YES	All

Syntax

trim(string[,leading=ktrue,trailing=ktrue,character=space_char])

Description

Removes the specified leading and/or trailing character from the string.

You specify the character to be removed in the character argument. If this is omitted the space character is removed from the string by default.

Example

Calculate
 
lString
 as 
trim
(
'   ABCDE'
)

# returns 'ABCDE'

 
Calculate
 
lString
 as 
trim
(
'*****ABCDE*****'
,
kTrue
,
kFalse
,
'*'
)

# returns 'ABCDE*****'