Skip to main content

Modifying the end of a URL using formula

  • November 19, 2020
  • 1 reply
  • 32 views

Hi everyone,
I’m really sorry for that (probably) stupid question but I can’t get a valid answer to my issue by searching alone ;(

I would like to be able to use a formula to replace :
“https://pbs.twimg.com/profile_images/1171057411806961666/jyWUG6oT_normal.jpg”
by
“https://pbs.twimg.com/profile_images/1171057411806961666/jyWUG6oT.jpg”

I just want to remove the end of the URL because the formating of the begining could change.

Thanks for your precious help :pray:

This topic has been closed for replies.

1 reply

I’ve made that
( NOT({Favicon} = ‘’), CONCATENATE(LEFT({Favicon},LEN({Favicon})-11), ‘.jpg’), ‘’)

I think it’s correct ?