TRIMX

Description

Removes leading and trailing space, line breaks, paragraph separators, and tab characters.

Syntax

TRIMX ( text )

Parameter Description
text Any text string.

Remarks

Text that is imported from another environment may require this function.

Examples

This function returns Student Name Grade Level Teacher Name:

TRIMX(" Student Name
Grade Level    Teacher    Name ")

See also

CLEAN

MID

REPLACE

SUBSTITUTE

TRIM