Other Usage

export long term row in csv

gibba
Path Finder

Hi everyone

i have this problem, when i write my seaerch table, i have a column with a long term of char
Example,

"field1"
"xxxxxxxxxx xxxxxxxxxxxx xxxxxxxxxxx xxxxxxxxx"

when i export my table in csv file i have this problem.

"field1"
"xxxxxxxxxxxxx

xxxxxxxxx

xxxxxxxxxx"

and after i lost a format with the other column

why?

Tags (1)
0 Karma

Supriya
Path Finder

@gibba I'm facing similar issue could you help me how it can be resolved?

0 Karma

woodcock
Esteemed Legend

Try adding this to the bottom to replace newlines with spaces:

... | eval field1 = replace(field1, "[\r\n]+", " ") ...

Chamrong
Explorer

You will need to convert into string first.
try this
| eval New_field="\""+tostring(field1)+"\""

0 Karma

gcusello
SplunkTrust
SplunkTrust

Hi gibba,
how many chars you have in your field?
you are speaking of outputcsv command or csv export by web interface?
Bye.
Giuseppe

0 Karma

gibba
Path Finder

Hi Giuseppe

i talk about a csv export by web interface.

the numbers of chars about my field is variable but usually is a large number because is a field description.

thanks

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 ...