String

Change to Upper Case

It converts the selected column value to capital letters. The transformed value can replace the existing column value or can be added as a new column.

The Change to Upper Case transform is applied to the Source column by creating a new column,

A new column gets created with the values mentioned in Upper case:

Change to lowercase

It converts the selected column value to the small case. The transformed value can replace the existing column value or can be added as a new column.

When the Change to lower case transform is applied on the Source column,

the Source column gets displayed in the lower case:

Change to Title Case

It converts the selected column value to the title case. The transformed value can replace the existing column value or can be added as a new column.

The Change to Title Case transform is applied to the Source column,

the Source values get changed into the title case:

Remove Trailing and Leading Characters

It removes trailing and leading characters from the column. The transformed value can replace the existing column value or can be added as a new column.

Padding character: Specify whether to remove whitespace or another character using the drop-down menu.
Custom padding character - If other is selected as a padding character, specify which character to be removed.

The Remove Trailing and Leading Characters transform is applied on the designation column where the preface 'Sr' custom padding is set to be removed from the new column,

A new column with designation values gets added without the 'Sr' prefix:

Remove Part of Text

It matches and removes the matching part or entire value based on the condition. The transformed value can replace the existing column value or can be added as a new column.

Operator: Select the operator required for matching from the list
Value: The value or pattern to be searched for in the selected column
Submit: Click the Submit option to apply the transform.

Remove Consecutive Characters

The transform removes the repeated whitespace or character and modifies the selected column /adds the result to a new column. It removes only the repetition.

Separator: it has values whitespace /other. If whitespace, the transform searches for multiple white spaces and returns a single-spaced value.
Custom repeated Character: When a repeated character is ‘Other,’ this provides an option to give the character whose consecutive occurrence must be searched.
Submit: Click the Submit option to apply the transform specification to the selected column.

The Remove consecutive characters transform is applied to the current_status column,

The consecutive character 'r' gets removed from the cells that contain the value 'Transferred'. It returns the current_status column as shown below:

Search and Replace

It searches and replaces the matching part or entire value based on the option selected. The transformed value can replace the existing column value or can be added as a new column.

Operator- Select the operator required for matching from the list. Operators include contains, equals, starts with, ends with, and regex match.
Value: It is the value or pattern to be searched for in the selected column.

The Search and Replace transform has been applied to the team column,

A new column gets added to the dataset with the set value for the replacement E.g., in the selected instant the BU 10 has been replaced with 105.

Extract Substring before Delimiter

It extracts the substring from the selected column, before the ‘nth’ occurrence of the delimiter specified where ‘n’ is the count. The transformed value can replace the existing column value or can be added as a new column.

Delimiter: The delimiter on whose occurrence the extract should happen.
Count: This value is mandatory and specifies the count of occurrence of the delimiter before which the extract should happen.

The below given example displays how the Extract Substring before delimiter transform extracts the first string from the expected_joining_date column and creates a new column expected_joining_date_extract_substring_before_delimiter1 displaying only the first string (only the year) value of the selected column.

Extract Substring at Position

It extracts the substring from the selected column based on the starting position and the length of the extract. The transformed value can replace the existing column value or can be added as a new column.

Position: This value is required and is the start position. It can be both a positive and negative number. If it is a positive number, this function extracts from the beginning of the string. If it is a negative number, this function extracts from the end of the string.
Length: This value is optional. It specifies the number of characters to extract. If omitted, the whole string is returned starting from the given position.

The Extract Substring at position transform is applied to the expected_joining_date with the 0 position and 7 as length value:

It returns a new column expected_joining_date_extract_substring_1 with the first 7 positions as the split string value is 0.

Split String

It splits the string based on condition. It displays new columns based on the number of delimiter and on position.

Use With: Specify whether to split with a delimiter or at a position
Delimiter: The delimiter on whose occurrence the split should happen
Position: After which position split should happen if the selected option for the Use with is position.

Here splitting of the column is done based on Delimiter. The applied Separator is '-' and the selected splitting rule is first 3 no. of fields.

The values from the expected_joining_date get splitted in 3 columns as displayed below:

Insert Character

It inserts the character entered after a specified position. The transformed value can replace the

existing column value or can be added as a new column.

Position: The position in the cell value, after which the character must be inserted. We can even pass comma-separated values.
Character: The character that should be inserted after the specified positions.