Advanced Grouping or Searching


I just imported a list of URLs from Google Analytics and want to group the URLs by similar features.

For example, I have a bunch of URLs that start with /members/


I also have other URLs that have


Is there a way to group these or to do a lookup on these so I can group these together easily?


First, take a look at the Formula field reference here: Text Functions

Create a Formula field that extracts a portion of the URL using the appropriate function.

For example, let’s say the URLs are in a field named “URL”.
LEFT(URL, 9) will display the first 9 characters of the URL, which is the number of characters in “/members/”.

You can then group or filter on this new field.