Splunk Search

rex error help

ilove275
Path Finder

The regular expression is correct according to RegExr, but i keep on getting this error

Error in 'rex' command: Encountered the following error while compiling the regex 'count(domain)=(?<count(domain)>.*)': Regex: syntax error in subpattern name (missing terminator)

Here is what i have in Splunk Search:

rex field=_raw "count(domain)=(?<count(domain)>.*)"

Thanks guys

Tags (1)
0 Karma

chimell
Motivator

hi
try this search code :

...................................|rex field=_raw "count\(domain\)\=(?<count_domain>[^\,]+)"|table count_domain
0 Karma

somesoni2
Revered Legend

Try this (run anywhere)

 index="AAAA" source="BBBB" | rex field=_raw "count\(domain\)=(?<domain_count>.*)," | rename domain_count as count(domain)

ilove275
Path Finder

Thanks for your help
^^

0 Karma

ilove275
Path Finder

sample log

05/20/2014 00:00:00 +0900, search_name=AAAAA, search_now=1400606400.000, info_min_time=1400511600.000, info_max_time=1400598000.000, info_search_time=1400606401.123, count(domain)=744788, date_wday=tuesday
Thanks

0 Karma

rakesh_498115
Motivator

Hi ilove275,

brackets inside the rex field name cause the syntax issue.changing the field name count(domain) to domain_count would help u solving the issue.

rex field=_raw "count\(domain\)=(?<domain_count>.*)"

Thanks.

ilove275
Path Finder

it doesn't come out the File name "domain_count" when I use "Rename" commamd

0 Karma

ilove275
Path Finder

field name's "count(domain)" not "domain_count"

My Splunk Search
index="AAAA" source="BBBB" | rex field=_raw "count(domain)=(?.) date_wday=(?.)" | table date_wday count(domain)

error
Error in 'rex' command: Encountered the following error while compiling the regex 'count(domain)=(?.) date_wday=(?.)': Regex: syntax error in subpattern name (missing terminator)

Thanks rakesh_498115

0 Karma

MuS
Legend

and don't forget to append a " at the end of the regex command

0 Karma

MuS
Legend

can you provide some sample events please?

0 Karma
Get Updates on the Splunk Community!

Introducing the Splunk Community Dashboard Challenge!

Welcome to Splunk Community Dashboard Challenge! This is your chance to showcase your skills in creating ...

Built-in Service Level Objectives Management to Bridge the Gap Between Service & ...

Wednesday, May 29, 2024  |  11AM PST / 2PM ESTRegister now and join us to learn more about how you can ...

Get Your Exclusive Splunk Certified Cybersecurity Defense Engineer Certification at ...

We’re excited to announce a new Splunk certification exam being released at .conf24! If you’re headed to Vegas ...