Skip to main content

Hi all! I'm trying to extract the ID from a google drives doc link, any ideas on how to do this? Knowing the ID of the file is the one after the /d/?

Hi @pedroarango11 - You can use a formula like this:

 

MID({URL}, FIND("/d/", {URL}) + 3, FIND("/edit", {URL}) - FIND("/d/", {URL}) - 3)

 

In this formula, replace {URL} with the field name or variable containing the URL string.

Here is how this formula works in action:

Hope this helps!

P.S. Kudos to Chat GPT whom I asked this question! 

Reply


Terms & Conditions