Splunk Search

How to extract the nth letter from these sample host names using regular expression?

imthesplunker
Path Finder

How to extract the nth letter from the host using regular expression?

Sample hosts are :-
host=abcdefpghijkl11 (prod )
host=abcdefsghijkl12 (stg)
host=abcdefdghijkl13 (dev)

0 Karma
1 Solution

somesoni2
Revered Legend

Try like this. e.g. if you want to extract 10th character,

your base search | eval mychar=substr(host,10,1)

Alternatively,

your base search | rex field=host "^\w{9)(?<mychar>\w)"

View solution in original post

0 Karma

somesoni2
Revered Legend

Try like this. e.g. if you want to extract 10th character,

your base search | eval mychar=substr(host,10,1)

Alternatively,

your base search | rex field=host "^\w{9)(?<mychar>\w)"
0 Karma

imthesplunker
Path Finder

Thanks !...

0 Karma
Get Updates on the Splunk Community!

Splunk Enterprise Security 8.x: The Essential Upgrade for Threat Detection, ...

 Prepare to elevate your security operations with the powerful upgrade to Splunk Enterprise Security 8.x! This ...

Get Early Access to AI Playbook Authoring: Apply for the Alpha Private Preview ...

Passionate about security automation? Apply now to our AI Playbook Authoring Alpha private preview ...

Reduce and Transform Your Firewall Data with Splunk Data Management

Managing high-volume firewall data has always been a challenge. Noisy events and verbose traffic logs often ...