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!

More Control Over Your Monitoring Costs with Archived Metrics!

What if there was a way you could keep all the metrics data you need while saving on storage costs?This is now ...

New in Observability Cloud - Explicit Bucket Histograms

Splunk introduces native support for histograms as a metric data type within Observability Cloud with Explicit ...

Updated Team Landing Page in Splunk Observability

We’re making some changes to the team landing page in Splunk Observability, based on your feedback. The ...