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.

Hidden character issue using Airtable with Zapier

Topic Labels: Automations
1152 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Philip_Eoute1
4 - Data Explorer
4 - Data Explorer

I have an integer from Airtable going to Zapier to use as a filename for a PDF, but the file that comes back to Airtable is named “20201140719%EF%BB%BF.pdf” instead of “20201140719.pdf” It’s some kind of UTF-8 Byte Order Mark or something.

I thought it might be a hidden character in the text field in Airtable, so I converted to an integer, but that didn’t fix it.

Screen Shot 2021-09-20 at 6.51.46 AM

1 Reply 1

Welcome to the community, @Philip_Eoute1! :grinning_face_with_big_eyes: Doing a straight hex-to-decimal conversion, EF BB BF translates to 239 187 191. According to this chart, that’s a zero width no-break space.

Somewhere a space is being added. If you’re using a formula to generate that number, make sure that there isn’t a space at the end. If you’re sure that there isn’t a space coming from Airtable, check to see if there’s a space somehow being added in Zapier.