Hidden character issue using Airtable with Zapier

[Philip_Eoute1]

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.

[Justin_Barrett]

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.