Help

Remove file name and () from Attachment URL

Topic Labels: Formulas
3091 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Jen_Gordon
4 - Data Explorer
4 - Data Explorer

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!

Jen_Gordon
4 - Data Explorer
4 - Data Explorer

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