Splunk Search

extract no.

splunkuseradmin
Path Finder

hi all
I have events in json format need to extract number from this sip:+1234566@12.23.34.45
example: i need +1234566 from this any regex exp for this ..... field name is "Routing-Number"
thanks

Tags (1)
0 Karma
1 Solution

Vijeta
Influencer

You can use this

rex field=_raw "sip:(?<RoutingNumber>\S+)@"

View solution in original post

0 Karma

vinod94
Contributor

Dyude!

You can try this,

| makeresults 
| fields - _time 
| eval data="sip:+1234566@12.23.34.45" 
| rex field=data "sip\:\+(?P<Routing_Number>.*)\@"
0 Karma

vnravikumar
Champion

Hi

Try this rex,

| makeresults 
| eval test="sip:+1234566@12.23.34.45" 
| rex field=test "sip:(?P<RoutingNumber>[^@]+)"
0 Karma

vnravikumar
Champion

Hi

Try the above rex, which extracts the required string with a minimum steps

https://regex101.com/r/ULGqk2/1

0 Karma

Vijeta
Influencer

You can use this

rex field=_raw "sip:(?<RoutingNumber>\S+)@"
0 Karma
Get Updates on the Splunk Community!

Splunk Observability Cloud | Unified Identity - Now Available for Existing Splunk ...

Raise your hand if you’ve already forgotten your username or password when logging into an account. (We can’t ...

Index This | How many sides does a circle have?

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

Registration for Splunk University is Now Open!

Are you ready for an adventure in learning?   Brace yourselves because Splunk University is back, and it's ...