Advanced Grouping or Searching


#1

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/

/members/profile.html
/members/browse.html
etc.

I also have other URLs that have

/page.html
/page2.html

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


#2

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.