Блог

Я использую datatables.net чтобы экспортировать CSV-файл из таблицы следующим образом:

              var buttonCommon = {
                 exportOptions: {
                     format: {
                         body: function (data, row, column, node) {
                             return data.replace(""", "");
                         }
                     }
                 }
             };

            <%--Data tables--%>
            var table = $('.table').DataTable({
                "paging": false,
                "ordering": false,
                "info": false,
                "searching": false,
                bSortCellsTop: false,
                dom: 'Bfrtip',

                buttons: [
                    $.extend(true, {}, buttonCommon, {
                        extend: 'csvHtml5'
                    })
                ]

            });
  

В результате ДОЛЖЕН получиться csv-файл без двойных кавычек, но они появляются….
Я посмотрел, и я не могу найти никого, кто столкнулся с этой проблемой? Есть идеи, что я делаю не так?

 "Receipt","Total","Date","","","","Total","Type","GL Code","Amount","","",""
"g092920","","09/29/2020","","","","","","106.104.0000","$37.52","","",""
"","","","","","","","","106.369.0009","$0.00","","",""
"g092920","","09/29/2020","","","","","","","$0.00","","",""
"g092920","","09/29/2020","","","","","","106.208.1000","$2.45","","",""
"g092920","","09/29/2020","","","","","","106.347.2040","$20.07","","",""
"g092920","","09/29/2020","","","","","","106.347.2050","$0.00","","",""
"g092920","","09/29/2020","","","","","","106.347.2050","$15.00","","",""
  

это все, что вам нужно, чтобы прекратить использование двойных кавычек вокруг строк, обратите внимание на параметр fieldBoundary:

             var table = $('.table').DataTable({
            "paging": false,
            "ordering": false,
            "info": false,
            "searching": false,
            bSortCellsTop: false,
            dom: 'Bfrtip',

            buttons: [
                $.extend(true, {}, buttonCommon, {
                    extend: 'csvHtml5',
                    fieldBoundary: ''
                })
            ]
        });