# Exploding fields

Data in one column can be split to separate essential information into individual fields.

### Delimited Text  <a href="#delimited-text" id="delimited-text"></a>

You might have critical data stored in a single column, separated by a delimiter. To apply transformations to this data, you need to segregate the values into different rows. In Turium, you can split fields in a column into separate rows based on a delimiter. The following delimiters can be used to split values:

* Comma
* Tab
* Pipe
* Whitespace
* Custom separator

{% hint style="info" %}
Note: If you choose Custom separator, you must use a regular expression (regex) to define the separator. Regular expressions allow the usage of intricate search patterns when breaking down the data in the column. Standard Java regular expression constructs are supported.
{% endhint %}

If the value does not contain the specified separator, no additional rows are created.

To split values based on a delimiter, follow these steps:

1. From the drop-down menu, click Explode > Delimited text.
2. Choose the delimiter to use for splitting the fields.

Turium divides the fields based on the chosen delimiter and adds the split-to-row directive to the recipe. When you run the data axon, the transformation is applied to all column values.

***


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.turium.ai/home/algoreus/turium-connector-documentation/turium-fabriq-overview/how-to-guides/soma-transformation-user-guide/exploding-fields.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.