TRIMBS function

Syntax

TRIMBS (dynamic.array)
CALL -TRIMBS (return.array, dynamic.array)

Description

Use the TRIMBS function to remove all trailing spaces and tabs from each element of dynamic.array.

TRIMBS removes all trailing spaces and tabs from each element and reduces multiple occurrences of spaces and tabs to a single space or tab.

If dynamic.array evaluates to the null value, null is returned. If any element of dynamic.array is null, null is returned for that value.

If you use the subroutine syntax, the resulting dynamic array is returned as return.array.

If NLS is enabled, you can use TRIMBS to remove white space characters such as Unicode values 0x2000 through 0x200B, 0x00A0, and 0x3000, marked as TRIMMABLE in the NLS.LC.CTYPE file entry for the specified locale.