Format Operations

Here are the 'Format' operations for string type transformation

Uppercase

Converts all characters in each row of the selected column to uppercase characters.

Lowercase

Converts all characters in each row of the selected column to lowercase characters.

Title Case

All major words are capitalized, while minor words are lowercase for each row in the column on which the operation is performed.

Example: input “lord of the rings” will convert to output “Lord Of The Rings”

Trim White Space

Returns a string with any leading and/or trailing whitespace characters in an input string removed.

Trim Quotes

Returns a string with any leading and/or trailing quotes in an input string removed.

Remove White Space

Removed all white space in a given string.

Encode Special Characters

Name	Character	Replacement
NON_BREAKING_SPACE	‘ ’	 
LESS_THAN	<	&lt;
GREATER_THAN	>	&gt;
AMPERSAND	&	&amp;
DOUBLE_QUOTATION_MARK	“””	&quot;
APOSTROPHE	‘	&apos;
CENT	¢	&cent;
POUND	£	&pound;
YEN	¥	&yen;
EURO	'€	&euro;
COPYRIGHT	©	&copy;
REGISTERED_TRADEMARK	®	&reg;