Eliminate spaces from an email field

Topic Labels: Automations
236 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

I am trying to send emails using the Gmail automation. The field I am using to route to the "To" field in the automation is an email field. The problem is, some of the emails were inputted with a space before or after them, which I suspect is preventing deliverability.

I tried using a formula field to trim the email field, but I route the formula field to the "To" field in the Gmail automation, it shows up blank as though there is no text in the formula field.

What is the best way to eliminate spaces in a field you intend to use in the Gmail automation's "To" field?

0 Replies 0