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
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 ...