Splunk Search

How to Remove brackets and its content?

cedmarjls32
New Member

Hi all,
I have a field named count2 with the following values :
count2
12
32(30)
14
76(23)
3

As mentioned in the title, I'd like to remove the brackets as well as their contents so it would look like this:

count2
12
32
14
76
3

Thanks

Tags (1)
0 Karma
1 Solution

stephanefotso
Motivator

Try regular expression or substr command

  .............  |rex field=count2 "(?<count>[^(])"|table count
SGF

View solution in original post

0 Karma

cedmarjls32
New Member

Thanks for your feedback but it looks like the rex command only returns the first digit of all values

count
1 instead of 12
3 instead of 32
1 instead of 14
7 instead of 76
etc..

0 Karma

cedmarjls32
New Member

Thanks a lot! It's working great!

0 Karma

stephanefotso
Motivator

Ok try this:

   .............  |rex field=count2 "(?<count>\d+)"|table count

or this

 .............  |rex field=count2 "(?<count>\d+)\("|table count
SGF
0 Karma

stephanefotso
Motivator

Try regular expression or substr command

  .............  |rex field=count2 "(?<count>[^(])"|table count
SGF
0 Karma
Get Updates on the Splunk Community!

March Community Office Hours Security Series Uncovered!

Hello Splunk Community! In March, Splunk Community Office Hours spotlighted our fabulous Splunk Threat ...

Stay Connected: Your Guide to April Tech Talks, Office Hours, and Webinars!

Take a look below to explore our upcoming Community Office Hours, Tech Talks, and Webinars in April. This post ...

Want to Reduce Costs, Mitigate Risk, Improve Performance, or Increase Efficiencies? ...

Splunk Lantern is Splunk’s customer success center that provides advice from Splunk experts on valuable data ...