we have a table with large text values . those values need to be truncated to single line
If you have one or a few columns in your table, you could use the substr function in your search to set a maximum number of characters.
E.g. to truncate the field "col" to 100 characters.
<your search>
| eval col = substr(col,0,100)
