Appending a new line character behind each user id for Excel exporting purposes

[RVDowning]

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?

[martinaire]

---

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.

---