Reporting

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

RVDowning
Contributor

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?

Tags (3)

martinaire
Explorer

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.


0 Karma
Get Updates on the Splunk Community!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...