Skip to main content
Question

How do I split text?

  • April 12, 2023
  • 4 replies
  • 301 views

RosalieSanchez

Hello,

I am having trouble splitting text during the action step. 

I was able to use the formatter to use the split text option to split the text into a list. However, when I go to map it in the different Hubspot fields it groups all the information into one cluster again.

 

I would like it to keep each output item as its own and not have them grouped together again. 

 

Does anyone know how I can fix this? Thanks! 

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

4 replies

ken.a
Forum|alt.badge.img+6
  • Zapier Staff
  • April 12, 2023

Hey there @RosalieSanchez,

Welcome to the Community! 🎉

Before we dig deeper into this, could you please share a detailed screenshot with how your Formatter step is configured? Please don’t include/blur out any personal information in the screenshot.

Thanks! 😊


RosalieSanchez

RosalieSanchez

I did it this way because I was trying to split all the information for everything after the “:”

For example my list reads:

  1. Food: Apples
  1. Transportation: Car

and I just want to to read

  1. Apples
  2. Car 

and for those line items to all be separate fields. 

 

What I did first is use the split text formatter to separate the “description” into a list. The I used the split text formatter to remove the all the information before the colon. However, it is still grouping it together. As one description and not separate fields. 


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • April 12, 2023

Hi @RosalieSanchez 

Good question.

Try this Segment Index option.

NOTE: If the list has a variable # of items, then the mapping of individual variables to the following steps may produce inconsistent results.