topic Re: export long term row in csv in Other Usage

export long term row in csv

gibba — Wed, 12 Apr 2017 09:53:20 GMT

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?

gcusello — Wed, 12 Apr 2017 10:10:30 GMT

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

gibba — Wed, 12 Apr 2017 10:14:56 GMT

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

Chamrong — Fri, 29 Nov 2019 19:27:49 GMT

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

woodcock — Tue, 03 Dec 2019 04:39:37 GMT

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

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

Supriya — Tue, 05 Oct 2021 17:34:37 GMT

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