String Operations

Accessed from right click column header menu. String operations can be carried out on any column as long as they are object data types and not float or int. You can change the column type in the context menu.

The following string methods are supported:

• split, with separator symbol - will create multiple new columns
• strip, remove whitespace
• lower
• upper
• title, convert to TitleCase
• swapcase
• len, length of string
• concat, concatenate strings in first two cols with given separator
• slice, slice string by start/end indexes
• replace