I've generated a list of unique user ids (using values()) which display as one per line on the screen with a message indicating there are 332 more values. So, I need to export the list, but would like to have one user id per line, instead of having them strung horizontally with each value separated by a space in the spreadsheet.
Is there a way to concatenate a new line behind each user id when it is extracted from the data?
Option #1
Do the following:
| eval user=user."
" |
There is a new line between the quotation marks. Use SHIFT+ENTER to insert the new line into the search field. This concatenates (appends) a new line at the end of each user value. I tested it and noticed inconsistent results (some values dissappeared). Make sure to validate it.
Option #2
Install Splunk for Excel Export. I have not tested this but it may work.