Remove file name and () from Attachment URL

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:

Thank you! jen

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. :slight_smile:

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

1 Like

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

1 Like