Skip to main content
nathan_emerson
nathan_emerson
New Member
November 27, 2014
Solved

Regexp_Matches, removing the { in the result?

  • November 27, 2014
  • 1 reply
  • 3910 views

Howdy folks,

 

I have created a custom data set to return the number of requests per parent domain (i.e. just the values before the country code) using the regexp_matches function. The results are returned within {} braces, is there a way to suppress these in the results?

 

Here is a sample of the output:

# domain visits 1 {bitdefender.net} 66113 2 {pubnub.com} 9583 3 {doubleclick.net} 9192 4 {serving-sys.com} 6127 5 {adnxs.com} 5700 6 {googlesyndication.com} 4765 7 {bing.com} 4530

 

 

Many thanks,

 

Nathan

Best answer by hzhao_FTNT

Hi Nathan, Sorry for my typo. Please use root_domain(hostname) to get it.  For results from "select regexp_matches() as xxx", you could use unnest(xxx) or trim(xxx:text, '{}'). But root_domain should be the easiest way.

 

hz

1 reply

hzhao_FTNT
Staff
hzhao_FTNT
Staff
November 27, 2014

Hi Nathan,

 

Maybe you can use root_main(hostname) to get parent domain.

 

Regards,

hz

nathan_emerson
nathan_emersonAuthor
New Member
November 28, 2014

Thanks for the suggestion, I get a no function exists error however. Do you know if I need to cast the hostname as something in particular inside this function?

 

Cheers,

 

Nathan

 

hzhao_FTNT
Staff
hzhao_FTNTAnswer
Staff
November 28, 2014

Hi Nathan, Sorry for my typo. Please use root_domain(hostname) to get it.  For results from "select regexp_matches() as xxx", you could use unnest(xxx) or trim(xxx:text, '{}'). But root_domain should be the easiest way.

 

hz

Terms & ConditionsAccessibility statement