Format Operations

Here are the 'Format' operations for string type transformation

Apply text casing, trimming, whitespace removal, and HTML encoding to string values.

String Format functions apply text transformation operations to each row in a selected column. They are available via the column context menu under Format > in the Table view.

To access these functions:

1. Open a dataset in Table view.

2. Click the menu icon (≡) on any text column header.

3. Hover over Format > to expand the submenu.

4. Select the desired transformation.

5. Alternatively click + icon if you would like to add the formatted value to a new column

To Uppercase

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

Example:

Input	Output
hello world	HELLO WORLD

To Lowercase

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

Example:

Input	Output
Hello World	hello world

To Titlecase

Capitalizes the first letter of each word in every row of the selected column.

Example:

Input	Output
lord of the rings	Lord Of The Rings

Trim WhiteSpaces

Removes any leading and trailing whitespace characters from the value in each row. Whitespace between words is preserved.

Example:

Input	Output
hello world	hello world

Trim Quotes

Removes any leading and trailing quote characters (" or ') from the value in each row. Quotes within the string are preserved.

Example:

Input	Output
"dataworkz"	dataworkz

Remove WhiteSpaces

Removes all whitespace characters from the value in each row, including spaces between words.

Example:

Input	Output
hello world	helloworld

💡 Note: This differs from Trim WhiteSpaces, which only removes leading and trailing spaces. Remove WhiteSpaces strips all spaces throughout the entire string.

Encode Special Characters

Replaces special characters in each row with their corresponding HTML entities. This is useful when preparing text for HTML rendering or web-based output.

The following characters are encoded:

Name	Character	HTML Entity
NON_BREAKING_SPACE	(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;