Splunk Search

How to concatenate fields?

uagraw01
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?

uagraw01
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?

uagraw01
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!

Best Practices: Splunk auto adjust pipeline queue

When you enable autoAdjustQueue in Splunk, maxSize should be understood as the queue size Splunk starts with ...

Laser Bananas and Edge Hubs: Exploring Operational Technology (OT) Data Through a ...

  OT is a different environment to traditional IT and can have interesting challenges when interfacing the ...

Event Series: Mastering AI Tokenomics and Splunk Agent Observability

Beyond the Black Box: Correlating AI Performance and Tokenomics with Splunk Agent Observability   As ...