Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Help with formula

Topic Labels: Automations
633 1
cancel
Showing results for 
Search instead for 
Did you mean: 
rmm
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello Everyone,

I am wondering if there is a formula to replace these characters "&lt;"  and "&gt;" that take the place of the "<"  and ">" when I import a CSV from Webflow into Airtable. Mailchimp is not able to read it as is. 

Thanks very much! 

1 Reply 1
AlliAlosa
10 - Mercury
10 - Mercury

Hi there! Try the SUBSTITUTE() function.

SUBSTITUTE(SUBSTITUTE({Field Name}, "&gt;", ">"), "&lt;", "<")