Hidden character issue using Airtable with Zapier

Topic Labels: Automations
626 1
Showing results for 
Search instead for 
Did you mean: 
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.