Trim() mvSQL database function in Jitterbit App Builder

Summary

Trims leading and trailing whitespace from a string.

Syntax

TRIM(<string>)

Parameters

string

The string to trim.

Returns

The trimmed string.

Examples

TRIM(' Hello World ')

Returns

Hello World