> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://help.syncspider.com/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# Split Field

## TABLE OF CONTENTS

* [1. What is Split Field](#1.-What-is-Split-Field)
* [2. Split Field Options](#2.-Split-Field-Options)
* [2.1 Name](#2.1-Name%C2%A0%C2%A0)
* [2.2 Set Number of fields](#2.2-Set-Number-of-fields%C2%A0%C2%A0)
* [2.3 Set Separator](#2.3-Set-Separator%C2%A0)
* [2.4 Field names](#2.4-Field-names%C2%A0-%C2%A0)
* [2.5 Select field to split](#2.5-Select-field-to-split%C2%A0)
* [3. Example and how to use it.](#3.-Example-and-how-to-use-it.)

### 
---
### 1. What is Split Field

A split field is used to split a field into 2 sub-fields or more depending on your use case.

The split field represents multiple fields whose values are made by using one column value. Each value of each field will be generated from the selected column value.

### 2. Split Field Options

![](https://storage.crisp.chat/users/helpdesk/website/-/d/9/0/9/d909af8874da4800/4204735c-bee9-48ee-b216-7e148c_1vfjl1z.png)

#### 2.1 Name

The name of the Split field you would like to see in the Mapping section.

#### 2.2 Set Number of fields

A number of fields that you would like to set under the Split field.

#### 2.3 Set Separator

* Comma,
* Period,
* Semicolon,
* Tab,
* Space
* Other ( For other you use the specific separator in that use-case, it can be any special character that is used for it)

#### 2.4 Field names
####

The name of the fields under the Split field.

#### 2.5 Select field to split

The field we are splitting this field from.

### 3. Example and how to use it.

Example:  Google Sheet to CSV (Using a full name to split it into a Name and a Surname)

To create and set a Split Field, We can do this by going to the mapping section, and on the bottom left corner click on the **"+"** sign then click on **Split Field**

![](https://storage.crisp.chat/users/helpdesk/website/-/4/a/a/8/4aa8268bec076000/39f0f6c8-9940-4eea-bda5-0f1cce_5kd0lu.png)

Here is how we configured it

![](https://storage.crisp.chat/users/helpdesk/website/-/e/8/a/8/e8a8d0030813f800/2aab26d4-a527-4bc0-a80f-3af3c7_hdwybq.png)

Name it as you wish, we set the number of fields to 2 because we only use 2 fields ( Name, Surname)

The separator is Space because in our google sheet it is set as space

![](https://storage.crisp.chat/users/helpdesk/website/-/c/f/0/f/cf0f243dedec500/15f71e59-1576-4e43-9d8b-536eb8_165axup.png)

Field names are Name And Surname as that is what we are trying to split here

And the field we are splitting is the Full name for this use case.

This is how the custom field will look like when it is done

![](https://storage.crisp.chat/users/helpdesk/website/-/9/4/6/b/946bbd4ce1cae800/6abf8bfe-4779-4ccc-bb80-29e72e_1mp9sgv.png)

Now we map them to their appropriate positions,

![](https://storage.crisp.chat/users/helpdesk/website/-/b/f/e/2/bfe2ebfa07161000/9da7d0f5-b118-4746-9644-984794_mnvc8q.png)

And as we can see everything transferred correctly from our "Preview Values" Option

![](https://storage.crisp.chat/users/helpdesk/website/-/1/1/f/6/11f67386d3ac7c00/df9859c7-f2be-4ac3-891b-2ae105_8wjj41.png)

With this, we will end our Split field article.

---

We hope that this covers everything. If you have any further questions or need additional clarification please reach out to us via [[email protected]](/cdn-cgi/l/email-protection#a6d5d3d6d6c9d4d2e6d5dfc8c5d5d6cfc2c3d488c5c9cb) or our Chat Widget!