Help

Re: Using an escape character in a formula?

1375 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Colin_Winhall
5 - Automation Enthusiast
5 - Automation Enthusiast

I’m using integromat to automate some data from google sheets to airtable.

In this automation flow, I’m using ({record ID} = ‘string’) formula to match the g sheet cell with the airtable record id. For the most part this worked just fine until it came across a record that also had ’ in the record. This, I presume caused an error in the formula to not match the string as it stopped after the ’ character thinking that was the end of the string.

Is there an escape character I can use in this formula to solve this issue? Or is this something I have to solve in the google sheet for the matching strings?

2 Replies 2
Zollie
10 - Mercury
10 - Mercury

One option is to use double rather than single quotes.

"StringWith'Apostrophe"

Otherwise you could escape it like this:

'StringWith\'Apostrophe'

Thanks Zollie,

Will give it a try!