extracting google docs id from url

[pedroarango11]

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/?

[preshetin]

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!