How to get Extension Name from File (Attachment Name)

Gracias · ‎Jun 03, 2022

I have multiple Files in my Airtable. I want a Column for the Extension of Files. Extensions are .Docx, .Xlxs, .PDF, .AI and Multiple Other. I did use the Trim Formula but its not working too well for me. Please help.

Vivid-Squid · ‎Jun 03, 2022

Hi @Gracias
If you only have one file per row this might get them

MID(Attachment, FIND('.', Attachment), 5)

If you have more than one you may need to look into scripting.