Splunk Search

How to filter name by id which start with a specific number?

eduspk
Explorer

Hi All

Please help me with rex to filter name by id which start with "9" .

Ex:

Sample log

ContactId:"12345,5678,9999",ContactName:"name1,name2,name3"

Result:

id name
9999 name3
0 Karma
1 Solution

vnravikumar
Champion

Hi @eduspk

Try the following and let me know

| makeresults 
| eval log="ContactId:\"12345,9345,9999\",ContactName:\"name1,name2,name3\"" 
| rex field=log "ContactId:\"(?P<id>.+)\"\,ContactName\:\"(?P<name>.+)\"" 
| makemv delim="," id 
| makemv delim="," name 
| eval temp =mvzip(id,name) 
| mvexpand temp 
| rex field=temp "(?P<id>\d.+)\,(?P<name>.+)" 
| regex id="^9.+" 
| table id name

View solution in original post

vnravikumar
Champion

Hi @eduspk

Try the following and let me know

| makeresults 
| eval log="ContactId:\"12345,9345,9999\",ContactName:\"name1,name2,name3\"" 
| rex field=log "ContactId:\"(?P<id>.+)\"\,ContactName\:\"(?P<name>.+)\"" 
| makemv delim="," id 
| makemv delim="," name 
| eval temp =mvzip(id,name) 
| mvexpand temp 
| rex field=temp "(?P<id>\d.+)\,(?P<name>.+)" 
| regex id="^9.+" 
| table id name

eduspk
Explorer

Works fine. Thanks

0 Karma
Get Updates on the Splunk Community!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...