Skip to main content
Question

Text formatter returns 2 emails


This post has been edited by a moderator to remove personal information. Please remember that this is a public forum and to remove any sensitive information prior to posting.

in the following string 

xxxx.xxxxx@gmail.com,06xxxxxxxx,xxxx, xxxxxx.xxxxx@gmail.com,076xxxxxx,xxxxx 

 

The formatter returns 2 outputs xxxx.xxxxxxx@gmail.com,xxxx.xxxxxx@gmail.com

 

 

 

Hi @JPBerger 

What is your question?

From the screenshots we can’t tell which Formatter event you are using. (e.g. Text > Extract Email Address)

 


Correct 

Using text > extract email address 


@JPBerger 

There are 2 email addresses in the input string, which is why 2 email addresses were extracted by the Formatter step and returned as an array of items.


Yes there are and I cannot change the input 

But I need to test against each output to update record in hubspot


Hi there @JPBerger,

I’m jumping in to see if I can help!

You may need to use another formatter step to split the email addresses. Could you please try using the Text in Formatter - Split Text?

Kindly give it a try and let me know how it goes? I'll keep an eye out for your response!


@JPBerger 

You can use the Looping app to iterate thru each: https://zapier.com/apps/looping/help

Action: Looping - Create Loop from Line Items


Thanks 

I tried split text but it does not work 
I cannot change the input that contains 2 emails 
 

 

The output on the split  as line items or as fields works but create 2 identical output
 

 

And on select text output in the next step, the input contains 2 emails . I tried to split that one again but it does not work - I keep getting a duplicate email output


Thanks for your help

 


@JPBerger 

You can use the Looping app to iterate thru each extracted email: https://zapier.com/apps/looping/help

Action: Looping - Create Loop from Line Items


I have a free account 

Loop is a pro feature


@JPBerger 

Zaps with 3+ Zaps also require a Zapier paid plan, so you even trying to use a Formatter step would require a Zapier paid plan.


Reply