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

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
0 Karma

stephanefotso
Motivator

Try regular expression or substr command

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

Splunk Life | Happy Pride Month!

Happy Pride Month, Splunk Community! &#x1f308; In the United States, as well as many countries around the ...

SplunkTrust | Where Are They Now - Michael Uschmann

The Background Five years ago, Splunk published several videos showcasing members of the SplunkTrust to share ...

Admin Your Splunk Cloud, Your Way

Join us to maximize different techniques to best tune Splunk Cloud. In this Tech Enablement, you will get ...