Splunk Search

How to concatenate fields?

LogUx
Motivator

Hello Splunkers!!

 

I have two fields AND I want to concatenate both the fields.

Location : 3102.01.03

element : S82(=3102+LCC60-550S5)

And I want a result : 3102.01.03.S82(=3102+LCC60-550S5)

 

I have tried Location.".".element but it is not working properly. Please suggest me a fic workaround.

 

0 Karma
1 Solution

ITWhisperer
SplunkTrust
SplunkTrust

Not sure it is "not working"

| makeresults
| eval Location="3102.01.03"
| eval element="82(=3102+LCC60-550S5)"
| eval field=Location.".".element

Can you provide more details of how it isn't working?

View solution in original post

PickleRick
SplunkTrust
SplunkTrust

It should work this way.

See the run-anywhere example

| makeresults 
| eval a="a", b="b", c=a.".".b

For future reference:

1) Please set the subject of your post to something more descriptive than just "SPL". You're posting in the Splunk Search section, we get that you probably need help with some SPL

2) Be more descriptive than "is not working". What do you mean by that? You get any error? You get blank result? You get just one field and not the other?

LogUx
Motivator

@PickleRick Thanks for your support, its working fine now.

 

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

Not sure it is "not working"

| makeresults
| eval Location="3102.01.03"
| eval element="82(=3102+LCC60-550S5)"
| eval field=Location.".".element

Can you provide more details of how it isn't working?

LogUx
Motivator

@ITWhisperer Its working fine as same as I already tried but now its working.

 

0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Skip the Awkward Silence: Have a .conf-ersation at .conf26

Picture this. You arrive at .conf26 already having your socializing and networking plans mapped out. No ...

Rethinking Zero Trust: From Product Purchases to Logical Control Evidence

Implementing Zero Trust (ZT) across complex environments often falters at the very beginning due to a ...

Preparing your Splunk Environment for OpenSSL3

The Splunk platform will transition to OpenSSL version 3 in a future release. Actions are required to prepare ...