Splunk Search

How to apply regex to a field in lookup file?

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

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

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

State of Splunk Careers

Access the Splunk Careers Report to see real data that shows how Splunk mastery increases your value and job satisfaction.

Find out what your skills are worth!