# 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.
* [x] **Padding character:** Specify whether to remove whitespace or another character using the drop-down menu.
* [x] **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.
* [x] **Operator:** Select the operator required for matching from the list
* [x] **Value:** The value or pattern to be searched for in the selected column
* [x] **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.
* [x] **Separator**: it has values whitespace /other. If whitespace, the transform searches for multiple white spaces and returns a single-spaced value.
* [x] **Custom repeated Character:** When a repeated character is ‘**Other**,’ this provides an option to give the character whose consecutive occurrence must be searched.
* [x] **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.
* [x] **Operator**- Select the operator required for matching from the list. Operators include contains, equals, starts with, ends with, and regex match.
* [x] **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.
* [x] **Delimiter:** The delimiter on whose occurrence the extract should happen.
* [x] **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.
* [x] **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.
* [x] **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.
* [x] **Position:** The position in the cell value, after which the character must be inserted. We can even pass comma-separated values.
* [x] **Character**: The character that should be inserted after the specified positions.
The Insert Character transform has been applied to the ***offered\_ctc*** column. The selected position is 0 and character to be added is $:
A new column gets added to the dataset with the set configuration for the ***Insert Character*** transform:
*
##
##
##
##
