This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Help

How to get Extension Name from File (Attachment Name)

Topic Labels: Formulas
534 1
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Gracias
4 - Data Explorer
4 - Data Explorer
See Solution in Thread

‎Jun 03, 2022 06:17 AM

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.

0 Kudos
Reply
1 Reply 1
Vivid-Squid
11 - Venus
11 - Venus
See Solution in Thread

‎Jun 03, 2022 08:11 AM

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.

0 Kudos
Reply
Copyright © 2023 Khoros, LLC