Parse keys to return portion of key with Regex

Hi! Looking for some regex help again...

I have an analytics tool which allows me to take Regex and pull out specific parts of a key. In my example below, I'm looking to pull out the values which are in the third slot of the delimiter ":" and I can use the $ to reference a value to return.

Example Keys
     gglp:paidsearch_nb:paid keyword:rewardsclub

Expected Result
     (no match expected)
     paid keyword

What I've tried:
This failed -->

Open in new window

This failed -->

Open in new window

and then I referenced $1  to return what was matched

Results Returned with what I've tried:
None -- all tries have failed. :( Help please!
Elizabeth "Smalls" EckelsDigital Analytics ConsultantAsked:
Who is Participating?
Rgonzo1971Connect With a Mentor Commented:

pls try to catch the second element (maybe $2)


Open in new window

Dan CraciunConnect With a Mentor IT ConsultantCommented:
Or stick with $1:

Or, if "gglp:paidsearch" is a constant:

Elizabeth "Smalls" EckelsDigital Analytics ConsultantAuthor Commented:
Thanks @RGonzo and @Dan - both worked great!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.