Question

Need help removing personal email from a string in Zapier's format text option.

  • 26 June 2023
  • 3 replies
  • 55 views

Userlevel 1
Badge

Dear community,

I set up the format text option as follows:

I want to replace my personal email from the string “Attendees Email” which contains the guest email as well as mine. Thus, I enter my email in “Find” and leave “Replace” empty to delete it.

It seems, that it actually splits it in two outputs rather than deleting my email (which is shown at 2):

When I use the output from the action in following steps, it still includes both emails:
 

Could you please help me how I could actually delete my email from the two email addresses?

Many thanks!


3 replies

Userlevel 7
Badge +14

Hi @greenhouseautomation 

Good question.

It’s likely due to the “Attendees Email” data point being an array of emails.

Try adding this step before: Formatter > Utilities > Line Items to Text

This will convert the array to a string.

 

Alternatively, you can use 1 Code step to do this.

Userlevel 1
Badge

Thanks, I did not see an option “Line Items to Text” so I solved it with a Code step.

Userlevel 7
Badge +14

@greenhouseautomation 

Help article about using the Formatter option: https://help.zapier.com/hc/en-us/articles/8496308258189-Convert-line-items-into-text-strings#1-add-a-formatter-step-to-your-zap-0-0

Reply