Splunk Search

How to extract numbers correctly

pomazanelvira
New Member

Hi!
I have this field in my log: callerSipNumber="18121710_text". How should I extract "18121710" and name it "number"?
I've tried |rex field=callerSipNumber "((?)[_\w+])". But it didn't give anything. Thanks a lot!

0 Karma
1 Solution

richgalloway
SplunkTrust
SplunkTrust

| rex field=callerSipNumber "(?<number>\d+)" will do it.

---
If this reply helps you, Karma would be appreciated.

View solution in original post

0 Karma

vnravikumar
Champion

Hi

Try this

| makeresults 
| eval test="callerSipNumber=\"18121710_text\"" 
| rex field=test "callerSipNumber=\"(?P<result>[\d]+)"
0 Karma

pomazanelvira
New Member

thank u for "makeresults" function

0 Karma

richgalloway
SplunkTrust
SplunkTrust

| rex field=callerSipNumber "(?<number>\d+)" will do it.

---
If this reply helps you, Karma would be appreciated.
0 Karma

pomazanelvira
New Member

thanks a lot!

0 Karma
Get Updates on the Splunk Community!

Good Sourcetype Naming

When it comes to getting data in, one of the earliest decisions made is what to use as a sourcetype. Often, ...

See your relevant APM services, dashboards, and alerts in one place with the updated ...

As a Splunk Observability user, you have a lot of data you have to manage, prioritize, and troubleshoot on a ...

Splunk App for Anomaly Detection End of Life Announcement

Q: What is happening to the Splunk App for Anomaly Detection?A: Splunk is officially announcing the ...