Extracting Filenames from Dropbox Download Links
Use GSheets to easily get the filename from a URL address

If you spend time wrangling product data or other spreadsheets with FQDNs (Fully qualified domain names) then you may need to split out the filename from the URL. Recently I had a customer whose product data was all in excel with links to the Dropbox image asset. Unfortutantly this makes life difficult for importing into an PIM or eCommerce platform such as Akeneo, BigCommerce or Shopify. 

Here is a quick formula to sperate the filename of URLs in excel

=REGEXEXTRACT(A1,"[^/]+$")

So if we have a cell with a URL such as 

https://www.dropbox.com/s/wlnb20hjaliqomy/E3DL-4-Ortho.jpg?dl=0

We will get a result of

E3DL-4-Ortho.jpg?dl=0 

which then you can remove the ?dl=0 using find and replace.

Now you can use the formula for any regular image resource address!

Extracting Filenames from Dropbox Download Links
Discourse Digital, DiscourseDigital 9 September, 2021
Share this post
Sign in to leave a comment
Increase Your Store's Social Value through Charity and Giving Solutions
Social giving allows responsible consumerism that you can easily add to your ecommerce app