export long term row in csv

[gibba]

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?

[Supriya]

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

[woodcock]

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

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

[Chamrong]

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

[gcusello]

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]

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