- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 20, 2021 03:57 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 20, 2021 10:51 AM
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.