3.2.50. STRIP(string[,[option][,char]]) Returns string after possibly stripping it of any number of leading and/or trailing characters. The default action is to strip off both leading and trailing blanks. If char (which must be a string containing exactly one character) is specified, that character will be stripped off instead of blanks. Inter-word blanks (or chars if defined, that are not leading of trailing) are untouched. If option is specified, it will define what to strip. The possible values for option are: [L] (Leading) Only strip off leading blanks, or chars if specified. [T] (Trailing) Only strip off trailing blanks, or chars if specified. [B] (Both) Combine the effect of L and T, that is, strip off both leading and trailing blanks, or chars if it is specified. This is the default action. STRIP( Foo bar ) > Foo bar STRIP( Foo bar , L) > Foo bar STRIP( Foo bar , t) > Foo bar STRIP( Foo bar , Both) > Foo bar STRIP(0.1234500,, 0) > .12345 STRIP(0.1234500 ,, 0) > .1234500
PREV NEXT