Archive

export long term row in csv

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

Esteemed Legend

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

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

Explorer

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

0 Karma

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

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
State of Splunk Careers

Access the Splunk Careers Report to see real data that shows how Splunk mastery increases your value and job satisfaction.

Find out what your skills are worth!