Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Remove file name and () from Attachment URL

Topic Labels: Formulas
1561 3
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi there! I’m trying to write a formula that will pull JUST the image url into my column. Not all of this add’l info:

Screen Shot 2020-07-27 at 5.52.43 PM

Thank you! jen

3 Replies 3

Welcome to the community, @Jen_Gordon!

I actually don’t know how to do this if you have more than one attachment in your Attachments field (I’m pretty sure that it would require a custom JavaScript to do that), but as long as you only have one attachment in your Attachments field, you could use this formula:

MID(
Attachments,
FIND("(",Attachments)+1,
LEN(Attachments)-FIND("(", Attachments)-1
)

There might be other ways of doing this as well!

Hope this helps! If this answers your question, could you please mark this comment as the solution to your question? This will help other people who have a similar question. :slightly_smiling_face:

I also forgot that @Justin_Barrett has previously solved this dilemma for multiple attachments!

Oh wow thank you so much @ScottWorld!! :heart_eyes: