Skip to main content
Best answer

How to reference individual items from a TextSplit formatter step


Forum|alt.badge.img

I need to reference the individual items from a TextSplit formatter step, but I can only reference the combined output in a single field.  See attached screenshots.  Any help is appreciated.

Best answer by pranayshinde

In your Formatter step, when setting up the Split Text action, make sure you choose the “Segment Index” option set to “All (as Separate Fields)”. This should output each segment into its own field so that you can map them individually.
 

Sometimes the output from a TextSplit step is treated as a line-item array that later gets merged when mapped into a field. A common workaround is to add an extra Formatter step:

  • First, use Formatter > Utilities > Line Item to Text to convert the array into a single comma-separated string.
  • Then add a Formatter > Text > Split Text step on that result using your desired delimiter and again choose “All (as Separate Fields)”.
View original
Did this topic help you find an answer to your question?

3 replies

Forum|alt.badge.img+3

In your Formatter step, when setting up the Split Text action, make sure you choose the “Segment Index” option set to “All (as Separate Fields)”. This should output each segment into its own field so that you can map them individually.
 

Sometimes the output from a TextSplit step is treated as a line-item array that later gets merged when mapped into a field. A common workaround is to add an extra Formatter step:

  • First, use Formatter > Utilities > Line Item to Text to convert the array into a single comma-separated string.
  • Then add a Formatter > Text > Split Text step on that result using your desired delimiter and again choose “All (as Separate Fields)”.

Forum|alt.badge.img
  • Author
  • Beginner
  • 10 replies
  • February 3, 2025

🤗 👏 Thank you!!!

I did try the Segment Index of “All (as Line-Items)”, and that didn’t work.  I guess I didn’t scroll down enough to see the “All (as Separate Fields)”, which works perfectly.  I’ll have to read up on what the value of the Line-Items option is as I can’t figure out a use case off the top of my head.


ken.a
Forum|alt.badge.img+6
  • Zapier Staff
  • 6301 replies
  • February 5, 2025

That’s awesome ​@promctllc! A huge thanks to ​@pranayshinde for pointing you in the right direction!

If you have any other questions, please don’t hesitate to reach out to the Community. We’re always happy to help! 🤗