Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

How to get Extension Name from File (Attachment Name)

Topic Labels: Formulas
1439 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Gracias
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
Vivid-Squid
11 - Venus
11 - Venus

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.