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
Leaked Photos of Ray-Ban Smart Glasses
Facebook & Ray-Ban Launch Smart Glasses Today