Skip to main content

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

3 replies

ScottWorld
Forum|alt.badge.img+20
  • Brainy
  • 8730 replies
  • July 27, 2020

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:


ScottWorld
Forum|alt.badge.img+20
  • Brainy
  • 8730 replies
  • July 27, 2020

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


  • Author
  • New Participant
  • 1 reply
  • July 28, 2020

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


Reply