topic Re: can I show less characters in my result table in Splunk Search

can I show less characters in my result table

fengl2 — Wed, 15 May 2013 02:21:33 GMT

I have a search using the splunk table commands, but the text in one fields is too long so that I can't see the whole result in one screen, is there a way to show only the first 30 characters in that fields, thanks in advance.

Re: can I show less characters in my result table

Ayn — Wed, 15 May 2013 04:36:45 GMT

You could truncate the field values using fieldformat:

... | fieldformat yourfield=substr(yourfield,1,30)

Re: can I show less characters in my result table

abancel — Fri, 18 Jan 2019 12:57:54 GMT

Adding to the above answer in case this can help someone, since it took me a while to figure this out.
If the field to be truncated happens to be a multi value field, it must first be converted to a string with mvjoin before being truncated.

Both commands can then be combined:
| fieldformat yourfield=substr(mvjoin(yourfield',", "),1,30)+"..."