Skip to main content

How to get Extension Name from File (Attachment Name)

  • June 3, 2022
  • 1 reply
  • 60 views
G

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

V
Forum|alt.badge.img+16
  • Vivid-Squid
  • Inspiring
  • June 3, 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.

Terms & ConditionsAccessibility statement