---
schema_version: "1"
id: d09815e603de3147f271bb70a511c7427f4cd73e9912910c6b0cf3f3951c67a6
title: "Split Transformation: Break Up Column Values"
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/data/264-0-0/c360_a_batch_transform_split.md
canonical_url: https://help.salesforce.com/s/articleView?id=data.c360_a_batch_transform_split.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 7f1a7ebfc5374e424b1cdb829c0b49b3636cec3db1dfc9441205f631837e42eb
description: Split a string in a text column into two values by specifying a delimiter. To split column values into more than two parts, add multiple instances of the split transformation. For instance, you can use three split transformations to split an address into street address, city, state, and ZIP code.
products:
  - Data 360
release: "264"
---
# Split Transformation: Break Up Column Values

Split a string in a text column into two values by specifying a delimiter. To split column values into more than two parts, add multiple instances of the split transformation. For instance, you can use three split transformations to split an address into street address, city, state, and ZIP code.

1. In a transform node, select the text column in the Preview tab.
2. In the transform toolbar, click the Split button (![Split button](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-data-data_cloud-264-0-0-production-enus/f3569962-3c9b-4f83-9d0c-b6a574e785da/resources-global/analytics/images/bi_button_split.png)).
3. Select the delimiter.
4. Enter the column labels for both new columns.
5. Click **Apply**.
    
    ![Tip](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-data-data_cloud-264-0-0-production-enus/f3569962-3c9b-4f83-9d0c-b6a574e785da/images/icon_tip.png)
    
    Tip To remove the original unsplit column, add the drop columns transformation after the split transformation.
6. To view the canvas, click the Collapse button (![Collapse button](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-data-data_cloud-264-0-0-production-enus/f3569962-3c9b-4f83-9d0c-b6a574e785da/resources-global/analytics/images/bi_button_collapse.png)).
7. Save the data transform.