Regex pattern help

Topic Labels: Data Formulas
639 2
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hi I want to extract a portion of a text from a google drive share link.

The format of the drive link is like this: 

I want to extract the text after "d/" and will end at before "/view". So the intended result should be "1IklI1OAW8XLtTKDfwW75BNcve8z8xQ57 "

Any ideas how?

Thanks a lot!

2 Replies 2
4 - Data Explorer
4 - Data Explorer

I think you can use the SUBSTITUTE function to achieve this. I did some testing with this formula I wrote and hopefully it helps!


Replace {link} with your correct field name, and it will pull the text you're looking for. 

How it works:

First, the formula calculates the inner-most part of the formula which is:

SUBSTITUTE({link}, "", "")

This searches your field for the string "" and replaces it with an empty string. 

Then the formula evalutes this new string against the outermost formula


It searches the new string for "/view" and replaces it with an empty string, leaving you with only the string you are looking for! 

11 - Venus
11 - Venus

Hi @neilr ,

In the case of REGEX, it is like this.