Splunk Search

How to apply regex to a field in lookup file?

pavanae
Builder

I have a lookup file query as follows

| inputlookup ABCD.csv which displays the results as follows

Host

efgh
ijkl.mno.com
pqrs.tuv.net
wxyz

Now how can i add a regex to display only the hostname and avoid the extra string which ever after the dot(.). I just want to apply the regex to display the result as follows

Host

efgh
ijkl
pqrs
wxyz

0 Karma
1 Solution

somesoni2
Revered Legend

Assuming you just want to manipulate the result of the search | inputlookup ABCD.csv, try like this

| inputlookup ABCD.csv | eval Host=mvindex(split(Host,"."),0)

OR

| inputlookup ABCD.csv | rex field=Host "^(?<Host>[^\.]+)"

View solution in original post

somesoni2
Revered Legend

Assuming you just want to manipulate the result of the search | inputlookup ABCD.csv, try like this

| inputlookup ABCD.csv | eval Host=mvindex(split(Host,"."),0)

OR

| inputlookup ABCD.csv | rex field=Host "^(?<Host>[^\.]+)"
Get Updates on the Splunk Community!

Why You Can't Miss .conf25: Unleashing the Power of Agentic AI with Splunk & Cisco

The Defining Technology Movement of Our Lifetime The advent of agentic AI is arguably the defining technology ...

Deep Dive into Federated Analytics: Unlocking the Full Power of Your Security Data

In today’s complex digital landscape, security teams face increasing pressure to protect sprawling data across ...

Your summer travels continue with new course releases

Summer in the Northern hemisphere is in full swing, and is often a time to travel and explore. If your summer ...