topic Re: Add newline into table cell? in Dashboards & Visualizations

Add newline into table cell?

inglisn — Tue, 28 Feb 2012 20:59:46 GMT

Hi,

I'm splunking some network traffic and want to generate a table showing the peak hour for different categories of data, for each day through a week. To add some context I'd like to embed more information (e.g. total throughput) into the table cell which I can do using eval to generate a result string.

Is there any way of creating a newline within the result string so that the values wrap onto multiple lines?

Thanks

Re: Add newline into table cell?

Ayn — Tue, 28 Feb 2012 21:17:53 GMT

You can do this by tweaking the CSS for the table you want wrapped text in (so you might need to create your own app so your CSS tweak doesn't affect everything else as well...)

To get wrapped text in the results table, define the following CSS in <app_root>/appserver/static/application.css:

.SimpleResultsTable table.simpleResultsTable {
    white-space:pre-line;
}

Re: Add newline into table cell?

inglisn — Tue, 28 Feb 2012 22:09:51 GMT

Thanks. Works well, although getting into the guts of CSS is something I was hoping to avoid.

Re: Add newline into table cell?

nagendra008 — Wed, 09 Mar 2016 05:34:43 GMT

Hi inglisn,

If you want to see the newline inside the table cell.
I tried using [ yoursearch | rex mode=sed field=Category "s/,/\n/g" | .... ], But i see space instead of newline.

Try this if you have a delimiter in the string for a field Category like shown in example : Cat1, Cat2
you can try to use split ( your search |eval Category = split(Category,",")| ....... ) after using all the methods split works fine for my case.
Hope this will help you.

Example :

No Category Count
1 Cat1, Cat2 5
2 Cat5, Cat6 9

Desired output :

No Category Count
1 Cat1 5
Cat2

2 Cat5 9
Cat6

Thanks.

Re: Add newline into table cell?

ZacEsa — Wed, 17 Aug 2016 01:08:21 GMT

Using split works for me.

Re: Add newline into table cell?

marcellodesales — Thu, 22 Sep 2016 04:26:31 GMT

Split worked for me as well...!

Re: Add newline into table cell?

bsanch2 — Thu, 27 Oct 2016 15:14:09 GMT

Split worked great, just what I was looking for!

Re: Add newline into table cell?

harry2007gsp — Tue, 09 Jan 2018 21:14:19 GMT

This was extremely useful. I have been looking for this for long.
Thank you @nagendra008

Re: Add newline into table cell?

spunk311z — Sat, 15 Aug 2020 18:18:52 GMT

thanks! this worked great for me as well. (nagendra008 's split method , not the css way)

(i didnt want to mess with CSS nor make a new app for a quick table).

if this helps others, i used the blank space as the linebreak / replace char;

| eval dateonly=strftime(_time, "%m-%d %A %I:%M%P") | eval dateonly= split(dateonly," ")

so i ended up with exactly what i wanted 🙂 -

vs this before 😐

(unrelated- what is up with the login process for the forums here? its now login on page 1, pw on page2, which breaks chrome and FF password save/remember. maybe they are doing this to fight off bruteforce/bots? etherway its pretty annoying as i now have to lookup + type both 😞