Skip to main content

Advanced Grouping or Searching

  • June 1, 2017
  • 1 reply
  • 3 views
M

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?

    This topic has been closed for replies.

    1 reply

    C
    • Christoff
    • Known Participant
    • June 1, 2017

    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.

    Terms & ConditionsAccessibility statement