Splunk Search

How do you take a value out of a field and make a new field with it?

aatha89
Explorer

How do i take out the port number (portnr) from the args field and make it to a field called "port" by a search? Can the answer here be to use eval and rex ?

Tags (1)
0 Karma
1 Solution

Vijeta
Influencer

Yes , you can use this rex command to get port- rex field=Args "_(?<port>\d{4})_"

View solution in original post

Vijeta
Influencer

Yes , you can use this rex command to get port- rex field=Args "_(?<port>\d{4})_"

aatha89
Explorer

Thanks :). Do you think i will need to use eval here? or will it just be fine to use rex ?

0 Karma

Vijeta
Influencer

rex will be fine, no need for eval if you just want to get port number in port field.

0 Karma

aatha89
Explorer

My logline her is:
_time command Args
24.05.1998 17:54 splunkA A_4040_restart

4040 is the portnr. I just want to take out portnr and put it a new field called port

0 Karma

kamlesh_vaghela
SplunkTrust
SplunkTrust

try this

YOUR_SEARCH  | rex field=args "_(?<port>.*)_"

Sample:

| makeresults | eval args="A_4040_restart" | rex field=args "_(?<port>.*)_"
0 Karma

aatha89
Explorer

Thank you very much!

0 Karma

kamlesh_vaghela
SplunkTrust
SplunkTrust

try
YOUR_SEARCH | rename portnr as port

0 Karma

aatha89
Explorer

Thanks for your reply! But my full question was:

My logline her is:
_time command Args // fields
24.05.1998 17:54 splunkA A_4040_restart //Values

4040 is the portnr. I just want to take out portnr and put it a new field called port

0 Karma
Get Updates on the Splunk Community!

Extending Observability Content to Splunk Cloud

Watch Now!   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to leverage ...

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 ...