Manipulate Text
Enables changes to text strings for a specific column within the selected table. The results can either Override Input Column, or create a new Column.
The available functions include:
Change Case
Changes all values to the selected case style:
lower case,
UPPER CASE
Capitalize Case (Title Case)
Trim
Removes text from beginning, end, or both beginning and end of the text string based on the selected character(s).
Common characters include Space, Semicolon, Comma, Tab. Multiple inputs can be selected. Selecting Other enables trimming based on unique inputs as needed.
Combine text
Enables combining values from columns within the selected table into a new column. All value types may be combined into the resulting text string and number values will be converted into text format. Values can have no separation or be separated by a selected character.
Extract (substring)
Extract text substring from column values by specifying starting position and the exact length of desired substring.
Output the results as a new column or override the input column.
Extract Domain from Email
Extracts the domain name from the selected column by searching for the “@” symbol. If the input text is not a valid email address, the results will be null.
Output the results as a new column or overrides the input column.
Left
Extracts the left most characters from the selected column text string. Select the length of the extracted string by choosing a static value or input a column with integers defining the length of the desired extracted text.
Output the results as a new column or override the input column.
Length
Returns the length of the value in the selected column. Results are output into a new column within the selected table.
Pad
Allows addition of specified number of characters to the left or right side of the input value. Select the desired string length and input a single character to be used for padding text strings which are shorter than the desired length. Output the results as a new column or override the input column.
Right
Extracts the Right most characters from the selected column text string. Select the length of the extracted string by choosing a static value or input a column with integers defining the length of the desired extracted text.
Output the results as a new column or override the input column.
Split
Enables splitting out text strings into a desired number of columns based on a selected character.
Results are output into new columns with the option to discard remaining text or to add remaining values to the final column.
Example with 3 new columns: “This - Text - Will be - Split - Up”
Left over values to the last column
This
Text
Will Be - Split - Up
Left over values discarded
This
Text
Will Be
Last updated
Was this helpful?