topic How to concatenate fields? in Splunk Search

How to concatenate fields?

uagraw01 — Sun, 12 Mar 2023 13:42:28 GMT

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.

Re: How to concatenate fields?

ITWhisperer — Sun, 12 Mar 2023 13:44:52 GMT

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?

Re: How to concatenate fields?

PickleRick — Sun, 12 Mar 2023 13:47:14 GMT

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?

Re: How to concatenate fields?

uagraw01 — Sun, 12 Mar 2023 13:53:03 GMT

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

Re: How to concatenate fields?

uagraw01 — Sun, 12 Mar 2023 13:53:40 GMT

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