TRIMS function

Syntax

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

Description

Use the TRIMS function to remove unwanted spaces and tabs from each element of dynamic.array.

TRIMS removes all leading and 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 TRIMS 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.