***
### Combine Columns Tile
The Combine Columns tile lets you combine values from multiple columns into one column. For example, you could combine first name and last name from two columns into a new, full name column.
**Video - Combining Columns in Magic ETL**
**To configure the Combine Columns tile,**
1. Click the
**Combine Columns** tile in the canvas.
2. (Optional) Rename the tile by clicking
The Replace Text tile lets you replace all occurrences of a text value with another text value (aka *search and replace* ). You can use Java regular expressions. For more information about Java regular expressions, see
[https://docs.oracle.com/javase/tutorial/essential/regex/](https://docs.oracle.com/javase/tutorial/essential/regex/)
.
**Magic ETL on Snowflake users:** Java regular expressions (RegEx) are not supported; instead, use SQL RegEx.
... with the text value "Ginormous"...
... using this configuration:
**To configure the Replace Text tile,**
1. Click the
**Replace Text** tile in the canvas.
2. (Optional) Rename the tile by clicking
Option | Description |
|---|---|
Whole words | Searches for whole words. |
Case sensitive | Searches with case-sensitive values. |
Use RegEx | Searches and replaces using Java regular expressions. |
The Split Column tile lets you split a single string column into multiple columns by a specific delimiter.
**Example**
For example, the Split Column tile converts data in this format...
...to data in this format...
...using this configuration:
**To configure the Split Column tile,**
1. Click the
**Split Column** tile in the canvas.
2. (Optional) Rename the tile by clicking
The String Operations tile lets you substring, trim, or pad a string with spaces.
**Example**
For example, the String Operations tile can transform this data...
... to this...
... using this configuration:
**To configure the String Operations tile,**
1. Click the
**String Operations** tile in the canvas.
2. (Optional) Rename the tile by clicking
The Text Formatting tile lets you format text (lower case, upper case, capitalization), remove numbers, or remove everything except numbers.
**Example**
For example, the Text Formatting tile transforms this data...
... to this...
... using this configuration:
**To configure the Text Formatting tile,**
1. Click the
**Text Formatting** tile in the canvas.
2. (Optional) Rename the tile by clicking