Remove Leading & Trailing Spaces (Trim)

Description

Trims all leading and trailing spaces from a string.

INPUT/Output DATA TYPE

Input	Output
text	text

 

example

In this example, the Idiom is the original column and Idiom - Clean shows the new values, with the leading and trailing spaces removed.