Export to CSV ignores <> characters.

maruthikumar80

Hello All,

When I export data from Datatable to csv format, it ignores < > characters.
For instance if the cell value is <>Maruthi, after exporting to csv it prints only Maruthi
Can anyone help me how to resolve this?

Regards,
Maruthi Kumar

colin

Hi @maruthikumar80 ,

I just tried it here, and it's working fine for me. Could you modify that example please so that it demonstrates your problem,

Cheers,

Colin

allan

Disable the stripping of HTML using the stripHtml option of the export button options (csvHtml5). The regex used for the stripping of HTML is overly simple and will just remove <> and anything between them.

Allan

maruthikumar80

Thank you, Allan. Now it is working. As you suggested I changed the option.
extend: 'csvHtml5',
exportOptions: {
columns: ':visible',
stripHtml : false
}

Regards,
Maruthi Kumar