Splunk Search

newline in Splunk query

v709587
Explorer

Hi,

Please help me with a newline command in Splunk query

Tags (1)
0 Karma
1 Solution

harishalipaka
Motivator

[Updated]

hi @v709587 try this below query

|makeresults |eval IMSI1="This is Splunk Dashboard. The list of hosts are as shown."   | makemv delim="." IMSI1 | mvexpand IMSI1 |table IMSI1

if you want to add new row try append, appendpipe

if you want to add new column try appendcols

Thanks
Harish

View solution in original post

0 Karma

harishalipaka
Motivator

[Updated]

hi @v709587 try this below query

|makeresults |eval IMSI1="This is Splunk Dashboard. The list of hosts are as shown."   | makemv delim="." IMSI1 | mvexpand IMSI1 |table IMSI1

if you want to add new row try append, appendpipe

if you want to add new column try appendcols

Thanks
Harish
0 Karma

v709587
Explorer

This works !!!. Thank You

0 Karma

v709587
Explorer

However,
"eval Impact=Column3.Column1" displays "Column1" and "Column3" as result and not the value of those parameters. Please help.

This is my query
|inputlookup file.csv | where Column1="$Column1$" and Column2="$Column2$" | return $Column3 | eval Impact=Column3.Column1 | makemv delim="." Impact | mvexpand Impact | table Impact

0 Karma

v709587
Explorer

$Column1
$Column1$
"$Column1"
"$Column$"

None of the above work.

0 Karma

vnravikumar
Champion

Hi
Can you give more information, what you are really expecting?

0 Karma

v709587
Explorer

eg: "This is Splunk Dashboard. The list of hosts are as shown."

I want to display these 2 lines in 2 different lines within same row, same panel.

0 Karma

vnravikumar
Champion

To understand more clearly, whether it is possible to give mock screenshot.

0 Karma

v709587
Explorer

Thanks Ravi for your help

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!

Build the Future of Agentic AI: Join the Splunk Agentic Ops Hackathon

AI is changing how teams investigate incidents, detect threats, automate workflows, and build intelligent ...

[Puzzles] Solve, Learn, Repeat: Character substitutions with Regular Expressions

This challenge was first posted on Slack #puzzles channelFor BORE at .conf23, we had a puzzle question which ...

Splunk Community Badges!

  Hey everyone! Ready to earn some serious bragging rights in the community? Along with our existing badges ...