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!

What's new in Splunk Cloud Platform 9.1.2312?

Hi Splunky people! We are excited to share the newest updates in Splunk Cloud Platform 9.1.2312! Analysts can ...

What’s New in Splunk Security Essentials 3.8.0?

Splunk Security Essentials (SSE) is an app that can amplify the power of your existing Splunk Cloud Platform, ...

Let’s Get You Certified – Vegas-Style at .conf24

Are you ready to level up your Splunk game? Then, let’s get you certified live at .conf24 – our annual user ...