Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Modifying the end of a URL using formula

Topic Labels: Formulas
246 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

I think it’s correct ?