Join the Conversation
- Find Answers
- :
- Using Splunk
- :
- Splunk Search
- :
- How do I extract a string of numbers using rex?
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark Topic
- Subscribe to Topic
- Mute Topic
- Printer Friendly Page
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I am dealing with a SQL log file.
The field I am attempting to extract a string of numbers from is called 'SQL_BIND'. I want to set the extracted string of numbers as field 'numbr'
The data in the SQL_BIND field is in the following form:
#1(8):xxxxxxxx #2(21):...
The xxxxxxxx represents the number I need to extract, the #1(8): exists at the beginning of each, and the #2(21): exists after the number followed by a random set of information (represented by the ellipsis).
I've attempted the following search to get a table of the results, but the table generates completely blankly.
index="main" | rex field=SQL_BIND "\(#1\(8\):()\(\s#2\(21\)" | table numbr
I think I'm using the \ before the parenthesis correctly to treat them as literal characters, but maybe not? I've been at this for hours, scouring the web for an answer or similar issue to figure it out... and so far no luck.
What am I doing wrong? This is driving me bonkers! Can someone please help?
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try this instead:
| rex field=SQL_BIND "#1\(8\):(?<numbr>\d+) #2\(21\)"
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You need to need to escape the parens with a backslash
... | rex field=SQL_BIND "\#1\(8\):(?<numbr>\d+)" | ...
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try this instead:
| rex field=SQL_BIND "#1\(8\):(?<numbr>\d+) #2\(21\)"
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you! This worked perfectly! Apparently I was overthinking it 🙂
Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!
Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.
[Puzzles] Solve, Learn, Repeat: Character substitutions with Regular Expressions
Splunk Community Badges!
[Puzzles] Solve, Learn, Repeat: Matching cron expressions
