Skip to main content
  • Home
  • Get Help
  • How Do I
  • How do I prevent the split text function from repeating items when creating line items in Zapier?
Question

How do I prevent the split text function from repeating items when creating line items in Zapier?

  • 9 August 2024
  • 2 replies
  • 15 views

Hi, I am using split text function to create line items for a list of 15 numbers separated by a comma.

For some reason, the output is repeating the 15 items five times under separate numbered arrays - see screenshot:

 

The problem is when I attempt to pull any of the single numbers out, it’s giving me this:

 

I could get there by running 15 separate formatter steps to give me the first number of each those rows (!) - but surely there must be an easier way?!

Ultimately, I want 15 numbers:

  1. 154
  2. 9
  3. 9
  4. 16 
  5. … etc. up to 15

ideally in 1 or max 2 steps. Any ideas please?

Hi @Hyde Phillips 

The data returned from GAnalytics4 is already formatted as an array of items.

 

How are you trying to use the data from Step 4 in following Zap steps that are NOT Formatter steps? (e.g. What is your end goal?) )screenshots for your Zaps steps after Step 5]

Hi @Hyde Phillips, 
You could not get all 15 at the same time. However, use the loop function or Zapier AI. The loop will make you able to return one by one all the values. while using Zapier AI you would be able to get 15 at the same time.
Regards,
Zaki
Business Workflow Consultant
>Ready Logic](https://www.readylogic.co)

Reply


Terms & Conditions