How to get Extension Name from File (Attachment Name)

Topic Labels: Formulas
534 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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.

1 Reply 1

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.