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!

SOCin’ it to you at Splunk University

Splunk University is expanding its instructor-led learning portfolio with dedicated Security tracks at .conf25 ...

Credit Card Data Protection & PCI Compliance with Splunk Edge Processor

Organizations handling credit card transactions know that PCI DSS compliance is both critical and complex. The ...

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

What are Community Office Hours?Community Office Hours is an interactive 60-minute Zoom series where ...