Help

Modifying the end of a URL using formula

Topic Labels: Formulas
919 1
cancel
Showing results for 
Search instead for 
Did you mean: 
HUBERT_QUETEL
4 - Data Explorer
4 - Data Explorer

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:

1 Reply 1
HUBERT_QUETEL
4 - Data Explorer
4 - Data Explorer

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

I think it’s correct ?