Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

How to create a URL by adding a slug from other column

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

Hi guys,

Actually I want to use this tool - https://statically.io/favicons/ which automatically grabs and display favicon of a any website if I write the URL in the format -

https://cdn.statically.io/favicons/domain.com

For example -

https://cdn.statically.io/favicons/google.com

Now, I already have a formula column which has multiple domain URL as the row cell value. Now, I want to create a new column with the following cell structure as shown above.

but here the domain .com should be replaced the domain URL written in that column. Now , what formula should I use to create a URL like this for different values of domain .com

Any help will be appreciated.

Thank you.

1 Reply 1

Hey, I think you can do this using SUBSTITUTE()

SUBSTITUTE(string, old_text, new_text, [index])

So

SUBSTITUTE({URL}, "domain", {newdomain})