Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Contact Us
  • Home
  • Built-in tools
  • Formatter
  • Text

Use Formatter to split text in Zaps

Written by Owner

Updated at August 20th, 2025

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Tables
    Work with tables Manage tables Create tables Troubleshoot Zapier Tables
  • Product updates
    Product updates: January 2023 Product updates: March 2023 Product updates: February 2023 Product updates: April 2023 Product updates: May 2023 Product updates: June 2023 Product updates: July 2023 Product updates: August 2023 Product updates: September 2023 Product updates: October 2023 Product updates: November 2023 Product updates: December 2023 Product updates: January 2024 Product updates: February 2024 Product updates: March 2024 Product updates: April 2024 Product updates: May 2024 Product updates: June 2024 Product updates: July 2024 Product updates: August 2024 Product updates: September 2024 Product updates: October 2024 Product updates: November 2024 Product updates: December 2024 Product updates: January 2025 Product updates: February 2025 Product updates: March 2025 Product updates: April 2025 Product updates: May 2025 Product updates: June 2025 Product updates: July 2025 Product updates: August 2025
  • Zaps
    Zap basics Zap history Troubleshoot Zaps Manage your Zaps Do more with Zaps
  • Your Zapier account
    Plans Billing Account profile Notifications Data privacy & security Get help User roles and permissions
  • Interfaces
    Troubleshoot Zapier Interfaces Create an interface Use interface components Manage interfaces
  • Canvas
    Create a canvas Collaborate on a canvas
  • Chatbots
    Add logic and knowledge to chatbots Troubleshoot chatbots Create chatbots Manage chatbots
  • Getting started
    Intro to Zapier Set up your Zapier account Use case templates
  • Agents
    Create agents Manage agents Troubleshoot agents
  • MCP
    Set up MCP
  • Built-in tools
    Filter & Paths Formatter Schedule & Delay Email, IMAP, SMTP, & Email Parser Webhooks & Code Storage, Digest, & RSS Sub-Zap & Looping Other built-in tools Custom Actions & API Requests Functions AI by Zapier & AI actions Copilot Human in the Loop
  • Lead Router
    Create routers
  • Apps
    Connect and manage your app connections AI apps on Zapier Apps on Zapier
+ More

Table of Contents

1. Add a Formatter step 2. Set up your transform 3. Test your action

Available on plans:

A green checkmark

Free

A green checkmark

Professional

A green checkmark

Team

A green checkmark

Enterprise

Use Formatter’s Text action to break up your data into segments by using the Split Text transform. This is helpful when you only want to use part of a field, or you want to break it up into smaller, separate segments.

Example

You can use the Split Text transform to separate first and last names to use in later steps.

1. Add a Formatter step

  • In the Zap outline, click the Action step or the plus sign + to add a new action. A dialog box will open.
  • In the search box, search for and select Formatter. The right sidebar will open to the Setup tab.
  • Click the Action event field to open the dropdown menu and select Text.
  • Click Continue to continue to the Configure tab.

2. Set up your transform

  • Click the Transform field to open the dropdown menu, then select Split Text.
  • In the Input field, manually enter the string you want to transform or map a field from a previous step.
  • In the Separator field, enter the value you want to separate on.
    • E.g. if there are commas between your values, type in a comma.
    • You must use a specific syntax for special characters, like spaces.
  • In the Segment Index field, select what output you want:
    • First: returns the first segment.
    • Second: returns the second segment.
    • Last: returns the last segment.
    • Second to Last: returns the second to last segment.
    • All (as Line-items): returns each segment as individual line-item values.
    • All (as Separate Fields): returns each segment as separate, mappable fields.
  • Click Continue to continue to the Test tab.
Note

You must use a specific syntax for special characters in the Find, Replace, and Default Value fields:

Syntax Special characters it replaces
[:space:] Use instead of space (\s) characters
[:tab:] Use instead of tab (\t) characters
[:newline:] Use instead of newline (\n) characters
[:return:] Use instead of carriage-return (\r) characters
Example

If you have a list of fruit: mango, passion fruit, pineapple, guava, mountain apple that you want to separate, you can enter ,[:space:] as the separator. Include both the comma and the space, so only the fruit is included in the output.

The output will depend on what option you select in the Segment Index field:

Segment Index Output
First mango
Second passion fruit
Last mountain apple
Second to Last guava
All (as Line-items)

mango

passion fruit

pineapple

guava

mountain apple

All (as Separate Fields)

mango

passion fruit

pineapple

guava

mountain apple

3. Test your action

  • Click Test step.
    • The Data out tab will display the transform output so you can confirm your string was formatted correctly.
    • If the new data is not what you expect, you can adjust the transform settings and retest the step again.
Tip

If you need to split text to meet token limits in AI steps, you can use the Split Text into Chunks for AI Prompt transform instead.

Was this article helpful?

Yes
No
Give feedback about this article

Related Articles

  • Modify large data for your AI prompts
  • Convert the letter casing in a text string in your Zaps
  • Remove extra text from your Zap data
  • Use Formatter to decode and encode HTML in Zaps
  • Count the number of characters or words in your Zap fields

Copyright 2025 – OBZ-Zapier.

Knowledge Base Software powered by Helpjuice

Expand