Skip to main content

Text.Trim

Removes all leading and trailing whitespace.

Syntax​

Text.Trim(
    text as text,
    optional trim as any
) as text

Remarks​

Returns the result of removing all leading and trailing whitespace from text value text.

Examples​

Example #1​

Remove leading and trailing whitespace from " a b c d ".

Text.Trim("     a b c d    ")

Result:

"a b c d"

Category​

Text.Transformations