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!

Stay Connected: Your Guide to May Tech Talks, Office Hours, and Webinars!

Take a look below to explore our upcoming Community Office Hours, Tech Talks, and Webinars this month. This ...

They're back! Join the SplunkTrust and MVP at .conf24

With our highly anticipated annual conference, .conf, comes the fez-wearers you can trust! The SplunkTrust, as ...

Enterprise Security Content Update (ESCU) | New Releases

Last month, the Splunk Threat Research Team had two releases of new security content via the Enterprise ...